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 votes131 views1 answer
Postgres select max value
SQL
0 vote127 views1 answer
Add timestamp column to existing table ms sql server
SQL
2 votes132 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote135 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
11 votes126 views2 answers
Having in sql
SQL
6 votes128 views3 answers
Mysql create database utf8
SQL
1 vote126 views1 answer
Show all event schedular on mysql
SQL
1 vote139 views1 answer
Oracle sequence last_number
SQL
3 votes152 views2 answers
Oracle drop column
SQL
0 vote122 views1 answer
Mysql range of dates overlap
SQL