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 vote210 views1 answer
Mysql add text to existing field
SQL
0 vote177 views5 answers
Linq cheat sheet
SQL
0 vote207 views1 answer
Test sql query
SQL
0 vote184 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
3 votes182 views1 answer
Select count from table mysql
SQL
0 vote173 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote182 views1 answer
Sql developer connect to sql server
SQL
7 votes183 views1 answer
Connect mysql docker
SQL
0 vote181 views1 answer
Mysql create table like
SQL
53 votes571 views6 answers
How to install mysql ubuntu
SQL