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 vote172 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote170 views2 answers
Mysql to python pandas
SQL
1 vote168 views1 answer
Postgresql transaction discard all
SQL
2 votes170 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote170 views1 answer
One table with another
SQL
0 vote164 views2 answers
Mysql on update current_timestamp
SQL
1 vote195 views1 answer
How do you use sql in you company
SQL
2 votes159 views1 answer
Add 2 hours to current time in MySQL
SQL
1 vote255 views1 answer
Oracle see column type
SQL
0 vote237 views1 answer
Sql database size
SQL