Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mani
After creating index by using CREATE command
CREATE UNIQUE INDEX IDX_EMP ON EMPLOYEE(EMP_ID)
To retreive index:
SELECT INDEX_NAME FROM USER_INDEX WHERE TBNAME='EMPLOYEE'
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is a db2 collection?
What is database reorganization?
Which command is used to connect to a database in DB2 ? Give the Syntax.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How do I add a column to a table in db2?
How do I import data from excel to db2?
How to access db2 tables in mainframe?
What is performance tuning db2?
What is isolation level in db2?
What is buffer pool?
What does a deadlock mean in DB2?
How to find schema of a table in db2?
What is ibm db2 connect?
Define check constraint.
What is the purpose of using commit?
