Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

MS SQL - "CREATE TABLE IF NOT EXISTS"

Ghastlie's profile image Ghastlie posted 6 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
Ghastlie's profile image Ghastlie posted 6 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.