Posts

Showing posts with the label current

SQL Script for Drop All Foreign Key Constraints from Current Database

SQL Script for Drop All Foreign Key Constraints from Current Database --Generate Script For Drop All Foreign Key Constraints From your Current Database SELECT ALTER TABLE +OBJECT_NAME(F.parent_object_id)+ DROP CONSTRAINT +F.NAME FROM sys.foreign_keys F Run the above Query. Output- ALTER TABLE BR_DTL DROP download  file  now