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 vote226 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote203 views1 answer
Sql get count without group by
SQL
2 votes206 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote192 views1 answer
Mysql money value
SQL
2 votes203 views1 answer
Sql find missing values between two tables
SQL
103 votes611 views2 answers
Sql server LIKE '%%'
SQL
6 votes207 views3 answers
Mysql first day of year
SQL
0 vote153 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote218 views1 answer
Mysql error 1251
SQL
0 vote316 views1 answer
Drop check command
SQL