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
- 15317 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
List out the buffer pools in db2
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the meaning concurrency in the db2 database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain dclgen.
What is the use of with ur in db2?
How to retrieve rows from a db2 table in embedded sql?
Which component is used to execute the sql statements?
What is package in db2 mainframe?
What is a dbrm in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Outputs of explain are with matchcols = 0. What does this signify?
How do I copy a table in db2?
Is ibm db2 free?
