How to drop primary and foreign key constraints from your tables in Microsoft SQL Server! Also how to check if the table has any constraints in the first place!
Script used in video:
SELECT
CONSTRAINT_NAME,
CONSTRAINT_TYPE
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
TABLE_NAME = 'YourTableName'
DROP CONSTRAINT [Constraint Name]
Drop a like if you found this video helpful!
