Free for PREMIUM members
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
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!