How to know the primary key of a table without defining the
primary key in the table?
- 5 Answers
- 13223 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
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is copy pending and check pending in db2?
What is the role of schema in the db2 database?
What is dclgen (declaration generator)?
What db2 400?
How to create backup table in db2?
Why do we bind in db2?
What are db2 tables?
What is the use of reorg in db2?
What is the use of commit in db2?
What is a bind in db2?
How many databases can be created inside an instance in db2 ?
How do I start db2 in windows?
Is db2 a database?
Explain about rct.
