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

27 votes359 views4 answers
Get all tables with column name sql
SQL
6 votes380 views1 answer
Identify primary key in oracle table
SQL
23 votes365 views3 answers
Mysqldump
SQL
1 vote358 views1 answer
Mysql copy table1 to table2
SQL
0 vote444 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote362 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote402 views1 answer
Insert value in identity
SQL
0 vote340 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote384 views1 answer
Sql make sure every user is unqiuew
SQL
10 votes374 views4 answers
Drop primary key
SQL