Question

sql怎么查看表中的主键 和主键列

Answer 1

方法：

select a.name 表名,a.name 主键名, c.name 列名 from sys.key_constraints a  
left join sys.index_columns b on a.parent_object_id=b.object_id
left join sys.columns c on b.object_id=c.object_id and b.column_id=c.column_id
left join  sysobjects d on a.parent_object_id=d.id where b.index_id=1

Answer 2

select cu.* from user_cons_columns cu,user_constraints au
where cu.constraint_name=au.constraint_name and au.constraint_type='P' and au.table_name=***

Answer 3

select a.name 表名,a.name 主键名, c.name 列名 from sys.key_constraints a
left join sys.index_columns b on a.parent_object_id=b.object_id
left join sys.columns c on b.object_id=c.object_id and b.column_id=c.column_id
left join sysobjects d on a.parent_object_id=d.id where b.index_id=1