Tag: SQL

How to find constraint names

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