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 vote394 views1 answer
Why do we need data structure in sql
SQL
14 votes311 views2 answers
Sql cast
SQL
0 vote330 views1 answer
Python sqlalchemy orm to select null values
SQL
1 vote340 views1 answer
Sql select all from one table and one column from another
SQL
5 votes377 views1 answer
Oracle source query
SQL
0 vote328 views1 answer
Import big data to mysql
SQL
2 votes333 views1 answer
Oracle percentage
SQL
1 vote336 views1 answer
Postgres get month name from date
SQL
-1 vote323 views1 answer
Count occurrences sql
SQL
0 vote334 views1 answer
Postgres read table structure
SQL