SQL搜索某个表的主键所在的列名

日常工作记录，北京网站建设公司在实际项目中遇到并觉得的实例：在SQL Server中使用SQL语句搜索某个表的主键所在的列名，语法如下：

SELECT SYSCOLUMNS.name
FROM SYSCOLUMNS,SYSOBJECTS,SYSINDEXES,SYSINDEXKEYS
WHERE SYSCOLUMNS.id = object_id('Tab_XXX')
AND SYSOBJECTS.xtype = 'PK'
AND SYSOBJECTS.parent_obj = SYSCOLUMNS.id
AND SYSINDEXES.id = SYSCOLUMNS.id
AND SYSOBJECTS.name = SYSINDEXES.name
AND SYSINDEXKEYS.id = SYSCOLUMNS.id
AND SYSINDEXKEYS.indid = SYSINDEXES.indid
AND SYSCOLUMNS.colid = SYSINDEXKEYS.colid

转载于:https://www.cnblogs.com/iceblog/p/sql-primary-key-column-name.html