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
- 15181 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 a trigger in the db2 database?
What is bind package and plan in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Define sqlca.
What is db2 purescale?
What is the default page size of buffer pools?
What is the difference between cursor stability and repeatable read isolation levels?
What is precompiler in db2?
What are the 2 sqlcodes that are returned?
What are the two types of logging in the db2 database? Explain them.
What is load replace in db2?
What is null in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How to check last update on table in db2?
