| index info [message #374813] |
Wed, 04 July 2001 07:11  |
Konstantin
Messages: 6
Registered: June 2001
|
Junior Member |
|
|
How can I know what columns does index include(if I don't remember)?
Thanks in advance.
|
|
|
|
| Re: index info [message #374815 is a reply to message #374813] |
Wed, 04 July 2001 07:44  |
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
|
Member |
|
|
hai Konstantin ,
Just check it in USER_IND_COLUMNS.
IF YOUR INDEX NAME IS EMP_IDX_1, THEN
SELECT COLUMN_NAME FROM USER_IND_COLUMNS WHERE
INDEX_NAME = 'EMP_IDX_1' ORDER BY COLUMN_POSITION;
Thats it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
