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
- 15337 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
Outputs of explain are with matchcols = 0. What does this signify?
Explain about rct in db2?
What is reorg and runstats in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
When the like statement is used?
How to test SQL -911 error while developing COB-DB2 program
Can we delete records from view?
Explain db2.
How does coalesce work?
What is null in db2?
What is role in db2?
What does sqlcabc has?
What type of database is db2?
What are host variables in db2?
What is bind plan?
