SELECT t.name AS tableName,
i.name AS pkName,
STUFF((SELECT ',' + c.name
FROM sys.sysindexkeys AS s2
INNER JOIN sys.[columns] AS c
ON c.column_id = s2.colid
AND c.[object_id] = t.[object_id]
AND s2.indid = i.index_id
AND s2.id = t.[object_id] FOR XML PATH('')
),1,1,'' ) AS pkColumnNames
FROM sys.tables AS t
INNER JOIN sys.indexes i
ON t.[object_id] = i.[object_id]
INNER JOIN sys.stats s
ON i.object_id = s.object_id
AND i.index_id = s.stats_id
AND i.is_primary_key = 1
--WHERE t.[object_id]=OBJECT_ID('表名')
查出表的主键及主键列
最新推荐文章于 2024-05-14 14:31:09 发布