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

1 vote135 views1 answer
What is a Database?
SQL
0 vote138 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
5 votes144 views1 answer
Oracle asynchronous update
SQL
8 votes131 views2 answers
Replace string value in sql
SQL
19 votes132 views4 answers
Rename database in sql
SQL
3 votes134 views1 answer
Postgres count distinct
SQL
4 votes161 views1 answer
Postgresql change default value
SQL
1 vote134 views1 answer
Mysql count words
SQL
0 vote139 views1 answer
Ffeathers express mysql application users login
SQL
4 votes130 views2 answers
Dbms_scheduler stop job
SQL