SqlServer 主键查询 四种找到SqlServer主键的方法

🔍 SqlServer主键查询 | 4种方法快速定位主键

1. 系统视图法 📊

   

   SELECT COLUMN_NAME 
   FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
   WHERE TABLE_NAME = '表名' AND CONSTRAINT_NAME LIKE 'PK%';

2. sp_pkeys存储过程 🔍

   EXEC sp_pkeys '表名';

3. sys.indexes联合查询 ⚙️

   

   SELECT c.name AS '主键列'
   FROM sys.indexes i
   JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
   JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
   WHERE i.is_primary_key = 1 AND OBJECT_NAME(i.object_id) = '表名';

4. SSMS可视化查看 👀
   右键表 → 设计 → 主键列旁显示🔑图标

💡 小贴士：方法1/2适合快速查询，方法3适合复杂场景,方法4适合图形化操作！