/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

2 votes337 views4 answers
Check timezone of mysql database
SQL
1 vote320 views1 answer
How to change owner in postgres
SQL
1 vote319 views1 answer
Tsql find foreign key references
SQL
0 vote354 views2 answers
Postgres isnull
SQL
2 votes307 views1 answer
Oracle create directory
SQL
7 votes337 views2 answers
Where keyword sql
SQL
3 votes335 views1 answer
Two select sql
SQL
0 vote274 views1 answer
Create bakupd database sqlserver
SQL
1 vote308 views1 answer
Apex run 404
SQL
1 vote310 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL