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 vote331 views1 answer
Sql multiple into
SQL
0 vote307 views1 answer
Mysql count unique in group statement
SQL
14 votes312 views2 answers
Oracle export trigger ddl
SQL
1 vote320 views1 answer
Oracle enable job
SQL
0 vote323 views1 answer
Exit psql
SQL
0 vote282 views1 answer
Oracle list dblink
SQL
0 vote303 views1 answer
Convert .mdf to .bak
SQL
0 vote320 views1 answer
Sql declare variable single line
SQL
0 vote295 views2 answers
Mysql to python pandas
SQL
0 vote328 views4 answers
Creating a comment and reply system PHP and MySQL
SQL