Answer Posted / dilon
index are nothing but primary key in the table...
ex:create table emp(eno numeric(4) not null primary key,
ename char(10) not null,
elocation char(10) not null)
in this example employee number eno is the primary key it is
called as index...
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are iseries servers?
How do I delete a table in db2?
Is db2 a database?
What is buffer pool?
What is the picture clause of null indicator variable?
What is the maximum size of a char data type in db2?
What is table space in db2?
What is the information associated with sysibm.syslinks table?
Give a brief description of db2 isolation levels?
When the like statement is used?
What is a collection in db2?
What is ibm db2 used for?
What is bufferpool in db2?