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 vote199 views2 answers
Port 5432 is already in use mac
SQL
10 votes180 views1 answer
Oracle view dependencies
SQL
0 vote188 views1 answer
Python connect microsoft sql server
SQL
1 vote202 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote187 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
13 votes187 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote184 views1 answer
Pl sql constraint user function
SQL
0 vote179 views1 answer
Mysql date minus 1 day
SQL
0 vote180 views1 answer
Show database not empty tables postgres
SQL
6 votes182 views1 answer
Phpmyadmin password root
SQL