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 vote182 views1 answer
Sql delete caracter list
SQL
2 votes147 views1 answer
Sql ignore accents
SQL
20 votes142 views2 answers
Counting in sql
SQL
0 vote159 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote156 views1 answer
Select tables with name like mysql
SQL
0 vote152 views1 answer
Use mysql in java program
SQL
0 vote149 views1 answer
Sql select all tables from database change url
SQL
0 vote154 views1 answer
Oracle c# multiple update sql
SQL
10 votes148 views3 answers
Insert into auto increment mysql
SQL
6 votes145 views5 answers
Mysql get last insert id
SQL