获取SQL Table 的PK 字段列表
-- 获取PK字段列表
select c.name
from sys.columns c
inner join sys.index_columns ic on c.object_id = ic.object_id and c.column_id = ic.column_id
inner join sys.indexes i on i.object_id = ic.object_id and i.index_id = ic.index_id
Where c.object_id = object_ID(N'Mail_Setting') and i.is_primary_key = 1
Order by c.column_id