-
Is their any system table or way to find out what column/columns are used to make index/ key ?
I tried this but it does not give the columns !!
SQLWKS> select * from user_indexes
2> where TABLE_NAME in ('MWEBAUTH', 'MWEBMATRIX')
3> order by table_name
INDEX_NAME TABLE_NAME
------------------------------ ------------------------------
IX_AUTH_WORK MWEBAUTH
SYS_C0039449 MWEBAUTH
UK_AUTH_1 MWEBAUTH
IX_MAT_RES MWEBMATRIX
SYS_C0039476 MWEBMATRIX
UK_MATRIX_1 MWEBMATRIX
In other words I want to know col1, col2, col3..
ix_auth_work is on (col1, col2, col3..) on table mwebauth
Thanks
Sonali
Sonali
-
system table 'all_ind_columns' will have all the info you need.
-
i have a script from one of oreilley's books, which generates the create index script for all indexes. This will also serve your purpose. If you need the script post your mail_id.
HTH
manjunath
-
My email id is sonaliak@hotmail.com
Could you send me that script please ?
thanks
Sonali
Sonali
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
|