/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 vote337 views2 answers
Change table name phpmyadmin
SQL
0 vote352 views1 answer
Sql put two columns into one
SQL
6 votes344 views1 answer
Sql insert values into table
SQL
0 vote357 views1 answer
Alter domain sql
SQL
4 votes312 views1 answer
Oracle show error line number
SQL
13 votes326 views4 answers
Mysql select last 10 rows
SQL
0 vote346 views1 answer
Mysql loop through databases and execute query
SQL
-1 vote352 views2 answers
Create temporary table sql
SQL
0 vote386 views1 answer
How to find date from date table in sql
SQL
0 vote363 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL