kdarty
11/3/2015 - 2:03 PM

The following SQL Script will retrieve a list of all "Unique" Constraints for a given Database. This is intended for use within SQL Server.

The following SQL Script will retrieve a list of all "Unique" Constraints for a given Database. This is intended for use within SQL Server. Other Constraint Types that can be queried: Foreign Key and Primary Key

Report-All-Unique-Constraints.sql
content_copyfile_download
-- StackOverflow Discussion: 
-- http://stackoverflow.com/questions/2675168/get-the-unique-constraint-columns-list-in-tsql
SELECT TC.CONSTRAINT_NAME, 
       CC.COLUMN_NAME, 
       TC.TABLE_NAME 
FROM   INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC 
       INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC 
               ON TC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME 
WHERE  TC.CONSTRAINT_TYPE = 'Unique' 
ORDER  BY TC.Constraint_Name;