Naveen Sangu
Reputation: 3
How to get the index KEY columns by query in db2 v6.1?
I am trying to get the Index key columns from Data base by using SQL.
Currently I am doing in manual way.
Please help me to get all the index key details from query.
FYI (SYSIBM.SYSINDEXES/SYSIBM.kEYS are not working, SYSIBM.tables working)
Upvotes: 0
Views: 1769
Answers (1)
Related Questions
- Get columns of index on DB2
- How to get column names from DB2
- How can I find all indexes available on a table in DB2
- How to identify primary key column in DB2 version 7.1
- How to find the name and value of a table's primary key in DB2
- Description of columns in a DB2 table
- How to find primary key on a table in DB2?
- Get all the index information for a given schema -- db2
- DB2 equivalent of [ColumnName]
- DB2: accessing the column by column number