Interested to Buy Any Domain ? << Click Here >> for more details...
How to know the primary key of a table without defining the
primary key in the table?
- 5 Answers
- 15524 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / nkv
Use the table name in SYSINDEXES to get the Primary index
name. The Primary index will have the value ‘P’ against
UNIQUERULE column in this table. Use this index name in
SYSKEYS table to get the column(s) in Primary key.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is db2? Explain.
What are the prerogatives?
How do I copy a table in db2?
How do you eliminate duplicate values in db2?
What is the result of open cursor statement?
Give the name of some fields form sqlca.
How to find the number of rows in db2 tables?
What is host variable?
What does reorg do in db2?
What is db2 connect?
Which are the db2 tools to protect integrity of the database?
Why do we need reorg in db2?
What is drop table?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are types of indexes?
