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
- 15356 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / ambika
u can use sysibm.syskeys to view the primary key of a
particular table provided if u have declared any attribute
as NOT NULL. if there are multiple columns of such kind u
the above procedure wont help.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to check table size in db2 sap?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is coalesce in db2?
What is image copy in db2?
What is the maximum No of rows per page?
What is catalog database in db2?
How would the varchar column remarks defined?
Mention the downsides of page level lock.
How do you pull up a query which was previously saved in qmf?
what is the sqlcode -501
What are the various data types available in db2?
What are concurrency issues?
Mention data types used in db2 ?
What are the 2 sqlcodes that are returned?
What is database alias db2?
