How to know the primary key of a table without defining the
primary key in the table?
Answers were Sorted based on User's Feedback
Answer / kums
you could use SYSIBM.SYSINDEXES table to know more about
the table index.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / priya shankar
If a column of the table uniquely defines each row in the
table then that column is called the Primary Key. Please
correct me if I am wrong.
Is This Answer Correct ? | 9 Yes | 9 No |
Answer / mani
Execute:
SELECT TBCREATOR, TBNAME, NAME, KEYSEQ
FROM SYSIBM.SYSCOLUMNS
WHERE TBCREATOR = 'creater id'
AND TBNAME = 'table-name'
AND KEYSEQ > 0
ORDER BY KEYSEQ
a nonzero value for KEYSEQ indicates the place of a column in
the primary key.
Is This Answer Correct ? | 2 Yes | 2 No |
my project is insurance management system,how to explain my work environment in interview?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
What is COPY PENDING status?
How do I add a column to a table in db2?
What is the difference between base table and view?
Which one allows duplicate values Union or Union All ?
what is different three logs in DB2?
How to find the maximum value in a column in the db2 database?
What do you do to keep the cursor from closing after a commit?
What types of tables are there in the db2 database?
What is subquery ?
What does db2 blu stand for?