Query to get Primary keys and Indexes



IBM's flagship relational database management system

Query to get Primary keys and Indexes

Postby prashanthreddy » Sat Jun 07, 2008 4:58 pm

Hi ,

Is there any query using which we can get the Primary keys for a particular table. If you have any queries to get Primary keys, foreign keys and Indexes please reply me.

Thanks,
Prashanth
prashanthreddy
 
Posts: 8
Joined: Sat Jan 19, 2008 3:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Query to get Primary keys and Indexes

Postby dick scherrer » Sat Jun 07, 2008 5:45 pm

Hello,

See if this will do what you want. . .

http://publibz.boulder.ibm.com/cgi-bin/ ... 0718164132
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post