/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

1 vote180 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote196 views1 answer
Md5 encryption for existing records
SQL
0 vote219 views1 answer
Finding leap year in sql
SQL
7 votes209 views2 answers
MySQL IF without else
SQL
-3 votes197 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
14 votes196 views3 answers
Sql trim from string
SQL
1 vote190 views1 answer
Varchar plsql
SQL
0 vote191 views1 answer
Sauvegarde complète my sql
SQL
0 vote194 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote142 views1 answer
Java spring boot connect to sql server
SQL