text: SELECT  OBJECT_NAME(ic.OBJECT_ID) AS table_name,
          COL_NAME(ic.OBJECT_ID,ic.column_id) AS primary_key
  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
  WHERE   i.is_primary_key = 1