SQL Server Performance

Drop Foreign Key Constraint

Discussion in 'General DBA Questions' started by iambhushan, Jul 26, 2007.

  1. iambhushan New Member

    Hi Everyone,

    I come accross a strange situation in database that I was not able to drop a foreign key constraint using the T-SQL script (even with GUI, it couldn't be dropped). there are no locks or blocking is going on these tables.

    USE [ARData]


    ALTER TABLE [dbo].[Table Name] DROP CONSTRAINT [FK_Constraint]

    the constraint has ON UPDATE CASCADE clause. I am not sure this would do something different to drop a foreign key constraint other than the above T-SQL statement. Anyhelp is greatly apprecaited.

    Bhushan Kalla
  2. bradmcgehee New Member

    What is the error message you are getting when you run the above command?

    Brad M. McGehee, SQL Server MVP
    Technical Editor/Moderator www.SQL-Server-Performance.Com
    Director of DBA Education for www.Red-Gate.Com

Share This Page