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

3 votes128 views2 answers
Oracle sql drop sequence
SQL
4 votes132 views1 answer
Create table if not exist in sqlite
SQL
7 votes136 views2 answers
How to create index mysql
SQL
2 votes119 views1 answer
Oracle sql day of month from date
SQL
0 vote126 views2 answers
Default constraint in ms sql
SQL
0 vote138 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote127 views1 answer
C# mysql update statement set value to null
SQL
1 vote146 views1 answer
Increase date by one day in sql oracle
SQL
0 vote186 views1 answer
Sql int vs integer
SQL
0 vote133 views1 answer
Sql find all different values in column
SQL