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 vote316 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote299 views1 answer
Get only first row mysql
SQL
10 votes329 views4 answers
Join with multiple conditions sql
SQL
8 votes443 views3 answers
Find table for column name in sql
SQL
3 votes322 views2 answers
Coalesce mysql
SQL
3 votes313 views1 answer
What is having clause
SQL
0 vote343 views2 answers
Athena drop partition
SQL
0 vote315 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote387 views1 answer
Mysql, how to query the table comments?
SQL
0 vote377 views1 answer
Acutal month year
SQL