Sql view index

-- Oracle  (all_indexes: depending on grants, dba_indexes: for all indexes))
SELECT index_name FROM user_indexes WHERE table_name = 'MY_TABLE';
-- List of indexed columns:
SELECT index_name, column_position, column_name
FROM user_ind_columns 		-- or all_ind_columns / dba_ind_columns
WHERE table_name = 'MY_TABLE'  
ORDER BY index_name, column_order;

Similar codes

1 vote200 views3 answers
How to get date in sql
SQL
0 vote235 views1 answer
Eliminate zero from integer mysql
SQL
0 vote196 views1 answer
Drop all triggers oracle
SQL
5 votes213 views1 answer
Dbms_metadata.get_ddl table
SQL
7 votes195 views1 answer
Postgres base size
SQL
27 votes250 views3 answers
Mysql delete row
SQL
0 vote194 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
3 votes191 views1 answer
Oracle apex call duration
SQL
0 vote186 views2 answers
Android sqlite query join
SQL
0 vote200 views1 answer
Replace string in whole database mysql stackoverflow
SQL