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 vote207 views1 answer
Populate db from command line postgres
SQL
0 vote195 views1 answer
Remove from table where
SQL
0 vote214 views1 answer
Null column as zero in mysql
SQL
0 vote225 views1 answer
DATEDIFF minute postgres
SQL
7 votes197 views3 answers
Postgre describe table
SQL
0 vote196 views1 answer
Limiting query result using where in sql
SQL
0 vote196 views1 answer
Mysql group by derived column
SQL
1 vote236 views1 answer
Alter database datafile maxsize 32g
SQL
21 votes203 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
4 votes199 views1 answer
Mysql ip address
SQL