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 vote211 views1 answer
How to remove default in mysql
SQL
0 vote215 views1 answer
How many columns can be used for creating index?
SQL
0 vote259 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
2 votes227 views1 answer
Oracle apex list connected users
SQL
0 vote242 views1 answer
Limit in access query
SQL
17 votes231 views3 answers
Postgresql version command
SQL
7 votes258 views2 answers
Phpmyadmin change password
SQL
0 vote231 views2 answers
Sqlite unix timestamp
SQL
4 votes229 views3 answers
Sql drop primary key
SQL
0 vote222 views1 answer
Mysql find missing values
SQL