What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-13 00:42:01
oracle list index on table
SELECT * FROM ALL_INDEXES -- or DBA_INDEXES or USER_INDEXES WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER'; -- Index columns SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME FROM DBA_IND_COLUMNS WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'... Add solution