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 vote189 views1 answer
Mysql get last 2 month data
SQL
0 vote185 views1 answer
Change filed order in mysql
SQL
-1 vote147 views2 answers
Datetime sql server week
SQL
4 votes224 views1 answer
How to drop a database in sql server when it is in use
SQL
2 votes213 views1 answer
Postgresql group by month and year
SQL
1 vote176 views1 answer
Convert to hexadecimal sql
SQL
1 vote182 views1 answer
Backup mysql data only
SQL
3 votes165 views1 answer
What is having clause
SQL
31 votes186 views3 answers
SQL Server change column data type
SQL
0 vote199 views2 answers
How to count codition
SQL