This blog shows how to drop a constraint from a table
Syntax:
ALTER TABLE tablename
DROP CONSTRAINT constraintname
SQL Server Transact Basic to Expert - Dropping Constraint from a table
SQL Server Transact Basic to Expert - Dropping Constraint from a table

Join the conversation! Your thoughts help the community grow.