Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to list indexes.

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I'm so green ...

I need to list the indexes for a table. As i see the command should be:
describe indexes for table <tablename>.

I'm getting no results, yet I know there are indexes for this table.

Also I get no results for:
describe table <tablename>

What command should I be using?
 
Run the following query:

Select indschema,indname,uniquerule,colnames from syscat.indexes where tabschema = 'schema' and tabname='table' order by indname
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top