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

3 votes227 views1 answer
Postgresql if null then 0
SQL
2 votes217 views1 answer
Oracle current date without time
SQL
-2 votes213 views3 answers
Sqlite reset autoincrement
SQL
0 vote237 views1 answer
Print boolean in plsql
SQL
0 vote250 views1 answer
Parent and child link in mysql
SQL
0 vote210 views1 answer
Sql server inner join convert collation
SQL
0 vote240 views1 answer
Mysql url
SQL
0 vote240 views2 answers
Select last 30 days sql
SQL
0 vote217 views1 answer
Can sqldatareader be null
SQL
0 vote209 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL