To get Table and column name for Primary Keys.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mohit Nayyar » To get Table and column name for Primary...

To get Table and column name for Primary Keys.

Rate Topic

Display Mode

Topic Options

Author

Message

Mohit Nayyar

Posted Wednesday, September 26, 2007 9:34 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 7:36 PM
Points: 148, Visits: 69

Comments posted to this topic are about the item To get Table and column name for Primary Keys.

Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com/
"If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

Post #403311

artvanhecke

Posted Saturday, November 13, 2010 7:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, November 13, 2010 7:59 PM
Points: 1, Visits: 1

Sorry 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_Management
SELECT o.name, c.name
FROM sysindexes ix
JOIN sysobjects o ON ix.id = o.id
JOIN sysobjects pk ON ix.name = pk.name
AND pk.parent_obj = ix.id
AND pk.xtype = 'PK'
JOIN sysindexkeys ixk on ix.id = ixk.id
AND ix.indid = ixk.indid
JOIN syscolumns c ON ixk.id = c.id
AND ixk.colid = c.colid
WHERE o.name = 'MAIL_MESSAGES'
ORDER BY ixk.keyno

Art

Post #1020397

« Prev Topic | Next Topic »

Permissions