Home » SQL & PL/SQL » SQL & PL/SQL » Viewing Index
Viewing Index [message #21120] Sun, 14 July 2002 22:04 Go to next message
Jayasri
Messages: 28
Registered: July 2000
Junior Member
Hi

How to find - all the columns which has been indexed in a particular table?

bye
Re: Viewing Index [message #21121 is a reply to message #21120] Mon, 15 July 2002 00:19 Go to previous message
Arvind L
Messages: 27
Registered: June 2001
Junior Member
Hi,

select * from dba_ind_columns
where table_name = 'table_name'

Another table dba_indexes can be queried for further information

-Arvind
Previous Topic: HOW TO COUNT TABLES IN A SCHEMA
Next Topic: transfer sql results to temp table
Goto Forum:
  


Current Time: Mon Jul 22 23:46:42 CDT 2019