/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

3 votes164 views1 answer
Oracle undo tablespace schema
SQL
2 votes144 views1 answer
Sql ignore accents
SQL
2 votes158 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote155 views1 answer
Intellij idea add mysql connector
SQL
0 vote142 views1 answer
Mysql 1 hour ago
SQL
2 votes102 views1 answer
Sql float to int
SQL
1 vote136 views3 answers
Sql server get week dates from week number
SQL
0 vote149 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote149 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote104 views1 answer
Ms sql - add one hour to time
SQL