The Dev Pages

A knowledge base for web applications development (and beyond)

Incorrect syntax near the keyword ‘FOREIGN’. MSSQL synatx

Posted on June - 27 - 2008

ALTER TABLE Project DROP FOREIGN KEY FK_Project_Template;
GO

SHOULD BE

ALTER TABLE Project DROP CONSTRAINT FK_Project_Template;
GO

« Coldspring init error – An error occured while Parsing an XML document.:Content is not allowed in prolog.

Throw errors in a cfscript and try catch in cfscript »

Tarun Said,
ALTER TABLE dbo.[TableName] DROP CONSTRAINT [FK_ForeignKeyName];

Add A Comment

Subscribe to The Dev Pages