Home » SQL & PL/SQL » SQL & PL/SQL » Index
Index [message #190009] Tue, 29 August 2006 00:47 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi,

How can i know a table contain index?


regards,
Sam
Re: Index [message #190020 is a reply to message #190009] Tue, 29 August 2006 01:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Yes you can. It is in the dictionary table USER_INDEXES and USER_IND_COLUMNS.

MHE
Re: Index [message #190027 is a reply to message #190009] Tue, 29 August 2006 01:41 Go to previous messageGo to next message
gopi_ora
Messages: 13
Registered: August 2006
Location: Bangalore
Junior Member
select * from user_indexes where table_name = '<Your Table>'
select * from all_indexes where table_name = '<Your Table>'
Re: Index [message #190039 is a reply to message #190027] Tue, 29 August 2006 02:06 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
gopi_ora wrote on Tue, 29 August 2006 08:41

select * from user_indexes where table_name = '<Your Table>'
select * from all_indexes where table_name = '<Your Table>'
Echo?

MHE
Previous Topic: how to disable one user and how to enable one user.
Next Topic: Sequence
Goto Forum:
  


Current Time: Sun Dec 04 14:38:12 CST 2016

Total time taken to generate the page: 0.11022 seconds