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
- 15320 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 reorg and runstats in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is the difference between oracle and db2?
How to view db2 table structure?
Give the name of some fields form sqlca.
What do you mean by rollback?
Define db2 and its databases?
What is dbrm in db2 database?
What is rct?
What is lock escalation in db2?
What is data manager?
What is runstats db2?
How does db2 sample database connect?
How connect db2 database to datastage?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
