/SQL/Lister les index d'une table oracle

Lister les index d'une table oracle

SELECT *
FROM ALL_INDEXES			-- or DBA_INDEXES or USER_INDEXES
WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER';

-- Indexes columns
SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS		-- or ALL_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;

Similar codes

3 votes101 views2 answers
Postgres inner join vs join
SQL
2 votes108 views1 answer
Add new column not null sql server
SQL
1 vote90 views1 answer
Using SQL in rails migration
SQL
0 vote107 views1 answer
Sql reverse order of results
SQL
0 vote104 views1 answer
Write SQL in ruby on rails
SQL
1 vote104 views1 answer
Update foreign key value in mysql
SQL
1 vote104 views1 answer
Oracle user last connected
SQL
0 vote109 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote114 views1 answer
How to truncate a table in databse
SQL
0 vote104 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL