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 votes142 views4 answers
How to alter table column name in mysql
SQL
0 vote132 views1 answer
Mysql update sum same table
SQL
12 votes139 views1 answer
Psql drop column
SQL
0 vote157 views1 answer
Command line mysql xampp
SQL
2 votes147 views2 answers
Postgres add column integer
SQL
1 vote168 views1 answer
Postgres select as csv
SQL
2 votes152 views3 answers
Current setting postgres timezone
SQL
0 vote163 views1 answer
Multiple like values for single column postgres
SQL
2 votes141 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote123 views2 answers
How to start postgresql laravel
SQL