sql2005取得TABLE主鍵及欄位名稱,說明

SELECT     i.name  AS  IndexName,  OBJECT_NAME (ic. OBJECT_ID )  AS  TableName,  COL_NAME (ic. OBJECT_ID ,ic.column_id)  AS  ColumnName, 
         isnull (e. [ value ] ,  '' )  as  evalue
FROM     sys.indexes  AS  i
INNER   JOIN  sys.index_columns  AS  ic  ON  i. OBJECT_ID   =  ic. OBJECT_ID   AND  i.index_id  =  ic.index_id
left   join  sys.extended_properties e  on  e.major_id = ic. object_id   and  e.minor_id = ic.Column_id  and  e.class = 1  
WHERE    i.is_primary_key  =   1
     and  ic. OBJECT_ID = object_id ( ' tablename ' )
order   by  ic.column_id

 

 

转载于:https://www.cnblogs.com/ywkpl/archive/2010/09/26/1836116.html