/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 vote241 views1 answer
Woocommerce mysql price table
SQL
0 vote251 views1 answer
QUERY JPQL
SQL
3 votes260 views4 answers
Ubuntu stop mysql
SQL
5 votes226 views3 answers
Mysql check if null or empty string
SQL
7 votes248 views1 answer
Mysql remote connection command line
SQL
1 vote236 views1 answer
Postgres delete from where date is greater than specific date
SQL
8 votes246 views1 answer
Sql remove leading spaces
SQL
1 vote230 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote242 views1 answer
Test sql query
SQL
0 vote234 views1 answer
Windows services sql
SQL