InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:47:16 GMT20http://www.sqlservercentral.com/Forums/Topic403311-613-1.aspxSorry for the three year old reply,You are right, it is a bit complicated. Your method may not return the columns in the correct order. Might I suggest:USE Case_ManagementSELECT o.name, c.nameFROM sysindexes ixJOIN sysobjects o ON ix.id = o.idJOIN sysobjects pk ON ix.name = pk.nameAND pk.parent_obj = ix.idAND pk.xtype = 'PK'JOIN sysindexkeys ixk on ix.id = ixk.idAND ix.indid = ixk.indidJOIN syscolumns c ON ixk.id = c.idAND ixk.colid = c.colidWHERE o.name = 'MAIL_MESSAGES'ORDER BY ixk.keynoArtSat, 13 Nov 2010 19:59:36 GMTartvanheckehttp://www.sqlservercentral.com/Forums/Topic403311-613-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/30755/">To get Table and column name for Primary Keys.</A>[/B]Wed, 26 Sep 2007 21:34:00 GMTMohit Nayyar