How to know the primary key of a table without defining the
primary key in the table?
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
Why cursor is used in db2?
How to find primary key of a table in db2?
What is null value in db2?
How would the varchar column remarks defined?
what is utility for parm lib
Define buffer pool.
What is rebind in db2?
What is the difference between spufi and qmf?
How do I import a csv file into db2?
What is a db2 cursor?
What is buffer pool?
What are union and union all?
What is the use of reorg in db2?
Define db2 and its databases?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2