Tag: SQL

Ever tried to drop a DEFAULT CONSTRAINT, how do you find the constraint name – try this:

USE [<database>]

EXEC sp_helpconstraint [<schema>.<table_name>]

GO

I found that little tip here: http://www.mssqltips.com/tip.asp?tip=1425