/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

12 votes187 views1 answer
Run mysql instance in docker
SQL
6 votes154 views5 answers
Get current date sql
SQL
0 vote186 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
2 votes193 views1 answer
Revokeprivileges mysql
SQL
6 votes164 views3 answers
Oracle all dates between two dates
SQL
23 votes161 views6 answers
Delete all rows from table sql
SQL
0 vote159 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
7 votes186 views5 answers
Max 3 salary in sql
SQL
0 vote165 views1 answer
Oracle right characters
SQL
0 vote189 views1 answer
Character count sql
SQL