OraFAQ Forum: SQL & PL/SQL

Tue, 29 August 2006 00:47

sam4all
Messages: 29
Registered: August 2006
Location: Bangalore

Junior Member

Hi,

How can i know a table contain index?

regards,
Sam

Tue, 29 August 2006 01:22

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Yes you can. It is in the dictionary table USER_INDEXES and USER_IND_COLUMNS.

MHE

Tue, 29 August 2006 01:41

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>'

Tue, 29 August 2006 02:06

Maaher
Messages: 7065
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: Tue Dec 03 05:31:48 CST 2024