查找主键

 select distinct db_name() as db, c.name sch,sp.name tbl,sc.name col from dbo.sysindexes si  INNER JOIN                               
               dbo.sysindexkeys sik    ON si.id = sik.id AND si.indid = sik.indid INNER JOIN                               
               dbo.syscolumns sc   ON sc.id = sik.id AND sc.colid = sik.colid INNER JOIN                               
               dbo.sysobjects so   ON so.name = si.name AND so.xtype = 'PK'
               
                inner join sys.sysobjects sp on so.parent_obj=sp.id
                inner join sys.schemas  c on c.schema_id=sp.uid
 order by db,sch,tbl