Search This Blog

Friday 18 May 2012

Query To Find Index Name and Index Column Name on Oracle Table



SELECT
SUBSTR(INDEX_NAME,1,30) INDEX_NM,
TABLE_NAME TABLE_NM,
COLUMN_NAME COLUMN_NM,COLUMN_POSITION
FROM  ALL_IND_COLUMNS
WHERE TABLE_NAME =UPPER('&TABLE_NAME')
ORDER BY INDEX_NAME,COLUMN_POSITION

No comments:

Post a Comment