select CCU.CONSTRAINT_NAME, CCU.COLUMN_NAME from INFORMATION_SCHEMA.TABLE_CONSTRAINTS as TC inner join INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE as CCU on TC.CONSTRAINT_CATALOG = CCU.CONSTRAINT_CATALOG and TC.CONSTRAINT_SCHEMA = CCU.CONSTRAINT_SCHEMA and TC.CONSTRAINT_NAME = CCU.CONSTRAINT_NAME where TC.CONSTRAINT_CATALOG = 'MyCatalogName' and TC.CONSTRAINT_SCHEMA = 'MySchemaName' and TC.TABLE_NAME = 'MyTableName' and TC.CONSTRAINT_TYPE = 'UNIQUE'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)