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.