-
How do I find out which columns are indexed in the table?
-
<font face=courier>
SQL> desc DBA_IND_COLUMNS
Name Null? Type
------------------------------- -------- ----
INDEX_OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
COLUMN_POSITION NOT NULL NUMBER
COLUMN_LENGTH NOT NULL NUMBER
DESCEND VARCHAR2(4)
</font>
Reddy,Sam
-
Here is a Query
Select Index_name, Table_Name, Column_Name
From Dba_Ind_Columns
where Upper(Table_name) = '&Table_Name';
It Will Give you the required results for particuler Table, If want all, Omit Where.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|