Home » SQL & PL/SQL » SQL & PL/SQL » How to get all created indeces that belongs to a special table
How to get all created indeces that belongs to a special table [message #282481] Thu, 22 November 2007 02:19 Go to next message
novalex
Messages: 19
Registered: November 2007
Junior Member
Hello!

with the help of the table USER_OBJECTS I can get all indeces from my databases (all tables). But I want to know how to get indeces that belongs to a special table? E.G. I have the table 'emp' and I want to know which indeces are created for this table.

Hope you can help me.

Thanks.
Re: How to get all created indeces that belongs to a special table [message #282484 is a reply to message #282481] Thu, 22 November 2007 02:32 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

This is always for you.

select * from user_indexes

Cheers,
Kiran Aithal
Re: How to get all created indeces that belongs to a special table [message #282485 is a reply to message #282481] Thu, 22 November 2007 02:34 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Rather

select * from user_indexes where table_name ='EMP';
Re: How to get all created indeces that belongs to a special table [message #282491 is a reply to message #282481] Thu, 22 November 2007 02:41 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALL_INDEXES (in case someone else created an index on your table).

Regards
Michel

[Updated on: Thu, 22 November 2007 02:41]

Report message to a moderator

Previous Topic: Codes not visible for Oracle Browser
Next Topic: Dynamic variable length
Goto Forum:
  


Current Time: Sat Dec 10 12:55:21 CST 2016

Total time taken to generate the page: 0.24953 seconds