How to correct these syntax errors in a SQL script generated by PowerDesigner in SQL Server?

Question

Msg 156 Level 15 State 1
Incorrect syntax near the keyword 'if'

Msg 156 Level 15 State 1
Incorrect syntax near the keyword 'then'

Msg 156 Level 15 State 1
Incorrect syntax near the keyword 'delete'

Msg 156 Level 15 State 1
Incorrect syntax near the keyword 'varchar'

Msg 156 Level 15 State 1
Incorrect syntax near the keyword 'restrict'

I can't seem to generate a complete and correct Database with this only 5 of the tables are generated.

Can you put the script back? It looks like it was dropped with Edit 4. — pascal, Apr 06 '17 at 13:41
From PowerDesigner, it looks like your model is using some version of SQL Anywhere / Adaptive Server Anywhere DBMS. What is your actual target DBMS? brand/name/version... — pascal, Apr 06 '17 at 13:43

score 0 · Answer 1 · answered Apr 06 '17 at 09:22

0

First of all, your generated syntax seems to be for SQL Server.

The correct MySQL syntax for dropping a foreignkey is:

alter table ARTICLE drop foreign key FK_ARTICLE_CONTENIR_ACHAT

And take note that the foreign key constraint has to be dropped by constraint name.

answered Apr 06 '17 at 09:22

Simon C

316
2
5

How do I drop a Foreign Key without knowing the name of the constraint? – Sona Legends Apr 06 '17 at 09:36
@SonaLegends: you cannot - you must know the name of the FK constraint. – marc_s Apr 06 '17 at 09:58

How to correct these syntax errors in a SQL script generated by PowerDesigner in SQL Server?

1 Answers1