/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

0 vote298 views1 answer
Check connections to database postgres
SQL
0 vote289 views1 answer
Mysql 8 error on identified by
SQL
8 votes394 views2 answers
Select current_timestamp - interval '3 days';
SQL
4 votes275 views1 answer
Oracle user tables
SQL
0 vote308 views1 answer
Sql select sum group by id laravel join
SQL
9 votes287 views5 answers
Sql limit
SQL
4 votes263 views2 answers
How to count items with same name in sql
SQL
0 vote343 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote303 views1 answer
Possgress drop if exists view
SQL
10 votes280 views4 answers
Join with multiple conditions sql
SQL