View previous topic :: View next topic |
Author |
Message |
misi Beginner
Joined: 14 Apr 2004 Posts: 13 Topics: 10
|
Posted: Tue Apr 20, 2004 4:35 am Post subject: Primary and Foreign Key |
|
|
How to find out priamry key in a db2 table . Also how to find the foreign key of the table?
misi |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
misi Beginner
Joined: 14 Apr 2004 Posts: 13 Topics: 10
|
Posted: Tue Apr 20, 2004 10:41 am Post subject: |
|
|
Thanks for the links, but I am getting a -551 error when running the queries. can you help me?
misi |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Apr 20, 2004 11:20 am Post subject: |
|
|
misi,
-551 erorr means that you do not have the Authorization to issue select statement on the catalog tables. Talk to your DBA and may be he can help out.
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|