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

9 votes169 views4 answers
Last mysql
SQL
10 votes161 views2 answers
Mysql drop database if exists
SQL
0 vote155 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote211 views1 answer
Add computed column to table sql server
SQL
7 votes156 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote160 views1 answer
If column value is null then in mysql
SQL
5 votes164 views6 answers
In operator sql
SQL
0 vote184 views1 answer
Eliminate zero from integer mysql
SQL
0 vote154 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote180 views1 answer
Varchar format not case sensitive sql
SQL