查询Sql Server Database中的唯一约束

with UniqueBasic as
(SELECTtab.name AS TableName, -- 表名称idx.name AS UniqueName, -- 唯一约束的名称col.name AS UniqueFieldName -- 唯一约束的表字段FROMsys.indexes idxJOIN sys.index_columns idxColON (idx.object_id = idxCol.object_idAND idx.index_id = idxCol.index_idAND idx.is_unique_constraint = 1)JOIN sys.tables tabON (idx.object_id = tab.object_id)JOIN sys.columns colON (idx.object_id = col.object_idAND idxCol.column_id = col.column_id)
) 
SELECT A.TableName,A.UniqueName,
(SELECT UniqueFieldName+',' FROM UniqueBasic t1 WHERE t1.UniqueName=A.UniqueName FOR XML PATH('')
) AS UniqueFieldNames
FROM UniqueBasic A 
WHERE A.UniqueName = 'Qywx_App_UniqueAgentId'
GROUP BY A.TableName,A.UniqueName

附录：