/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 vote382 views1 answer
Min mysql
SQL
0 vote360 views2 answers
Tsql row number
SQL
0 vote326 views1 answer
Hallo
SQL
0 vote339 views1 answer
Mysql local password denied
SQL
1 vote360 views1 answer
Mysql select all and rename one
SQL
0 vote361 views1 answer
Sql #region
SQL
0 vote422 views2 answers
Check if sql temp table exists
SQL
0 vote369 views1 answer
Oracle session statistics
SQL
0 vote368 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote351 views1 answer
Sp in sql server
SQL