Use alter table to drop a constraint; for example:
alter table titles drop constaint advance_chk
See “Using sp_helpconstraint to find a table’s constraint information”.
