SQL Server 查询表的主键的两种方式

方式2：

SELECT a.name 
  FROM   syscolumns a 
  inner  join sysobjects d on a.id=d.id       
  where  d.name=‘products‘ and exists(SELECT 1 FROM sysobjects where xtype=‘PK‘ and  parent_obj=a.id and name in (  
  SELECT name  FROM sysindexes   WHERE indid in(  
  SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid  
)))

方式3：

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE   
WHERE TABLE_NAME=‘PDA_xjData‘ 

SQL Server 查询表的主键的两种方式

标签：mat   and   products   type   方式   查询   data   str   where