Need to edge out the competition for your dream job? Train for certifications today.
CREATE TABLE boo (foo varchar(100) DEFAULT 'banana')
SELECT t.name, c.name, dc.definition
FROM sys.tables t
JOIN sys.columns c ON t.object_id = c.object_id
JOIN sys.default_constraints dc ON c.default_object_id = dc.object_id
WHERE c.name = 'foo'
Open in new window
EXEC sp_help table_name
EXEC sys.sp_helpconstraint table_name
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
This course teaches how to install and configure Windows Server 2012 R2. It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).