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]

    GO

    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
    www.sqlbrad.com
    www.sqlHawaii.com

Share This Page