/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

17 votes187 views6 answers
What is cursor in sql server with example
SQL
0 vote236 views1 answer
Mysql dump with table query
SQL
0 vote213 views2 answers
Sql server select first day of previous year
SQL
0 vote213 views1 answer
How to retrive the today date sql
SQL
0 vote266 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
1 vote198 views1 answer
MySQL AND Operator
SQL
0 vote216 views1 answer
Get enginge db mysql
SQL
5 votes235 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
1 vote209 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote218 views1 answer
Postgresql heritage
SQL