KnowledgeBase
a KnowledgeBase blog for my random thoughts and observations...
Thursday, April 10, 2014
List all Database Constraints
SELECT
DISTINCT
Constraint_Name AS [Constraint],
Table_Schema AS [Schema],
Table_Name AS [TableName]
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where Constraint_Name like '%Service%'
GO
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment