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
- 15134 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
Mention the various locks that are available in db2.
What is the information associated with sysibm.syslinks table?
What is ibm db2 client?
What is buffer pool in the db2 database?
Why cursor is used in db2?
How do we specify index to include or not during bind process.
How to check table size in db2 sap?
Which component is responsible for processing sql statements and selecting access paths?
What is precompiler in db2?
How to check last update on table in db2?
What is cobol db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is db2 optimizer?
How do I delete a table in db2?
