MS SQL - "CREATE TABLE IF NOT EXISTS"

[expired user #9075]'s profile image [expired user #9075] posted 9 years ago in Import/Export Permalink
Morning folks,

Latest HeidiSQL (9.2.0.4947 x64), MS SQL Server 2005 and MS SQL Server 2012. When exporting/importing, HeidiSQL is using "DROP TABLE IF EXISTS" and "CREATE TABLE IF NOT EXISTS", resulting in error messages about incorrect syntax near IF.

Any help at all?

Cheers
[expired user #9075]'s profile image [expired user #9075] posted 9 years ago Permalink
Hmm... No edit button. Apologies for the double-post.

I may have found my answer here.

It's only 52,000 lines...! ;)

Please login to leave a reply, or register at first.