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
Comments
Post a Comment