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

0 vote179 views1 answer
Postgres week number
SQL
0 vote177 views1 answer
Sql compound operators
SQL
2 votes138 views2 answers
Mysql get last character of string
SQL
1 vote197 views2 answers
Restart identity cascade
SQL
6 votes185 views2 answers
Mysql execute file
SQL
0 vote199 views1 answer
How to close external sql connection in laravel
SQL
8 votes227 views1 answer
Oracle add datafile to tablespace
SQL
17 votes191 views2 answers
T_sql contains
SQL
7 votes187 views2 answers
MySQL IF without else
SQL
0 vote189 views1 answer
What is delimiter in mysql
SQL