Drop Constraints

Use alter table to drop a constraint.

For example:
alter table titles
drop constaint advance_chk
Related concepts
Use sp_helpconstraint to Find Table Constraint Information