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
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
