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
- 15371 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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is alias in db2?
Which command is used to remove all rows from a table?
What is runstats and reorg in db2?
What is runstats utility in db2?
Why do we need reorg in db2?
what is diffrence b/w file-aid tool and file-aid utility???
what are bind concepts in db2 cobol?
What is the difference between db2 and oracle?
List out the data types available.
What does db2 plan contain?
What are the full forms of spufi and dclgen and why are they used?
Give the name of some fields form sqlca.
What are the bind parameters ibm db2?
What is db2 connect?
