A knowledge base for web applications development (and beyond)

Incorrect syntax near the keyword ‘FOREIGN’. MSSQL synatx

ALTER TABLE Project DROP FOREIGN KEY FK_Project_Template;
GO

SHOULD BE

ALTER TABLE Project DROP CONSTRAINT FK_Project_Template;
GO

One thought on “Incorrect syntax near the keyword ‘FOREIGN’. MSSQL synatx”

Tarun says:

December 16, 2009 at 10:21 pm

ALTER TABLE dbo.[TableName] DROP CONSTRAINT [FK_ForeignKeyName];