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

1 vote151 views1 answer
DATE_SUB postgres
SQL
0 vote119 views1 answer
Create duplicate table postgres
SQL
4 votes172 views3 answers
NOT NULL SQL
SQL
0 vote197 views2 answers
Search stored procedures by name
SQL
0 vote155 views1 answer
Create column that already exists mysql
SQL
0 vote156 views1 answer
Jdbc sql connection string
SQL
3 votes149 views1 answer
Sql case update
SQL
0 vote188 views1 answer
Set Mamp mysql globally
SQL
5 votes149 views2 answers
Postgres update with if condition query
SQL
0 vote156 views1 answer
Ansi sql count duplicate rows
SQL