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

28 votes314 views6 answers
Sql update
SQL
1 vote292 views1 answer
Date_part mysql
SQL
6 votes280 views2 answers
How to copy data in sql
SQL
0 vote297 views1 answer
Psql get table data types
SQL
3 votes363 views1 answer
Sql select second max
SQL
18 votes256 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
3 votes263 views2 answers
Oracle for loop
SQL
2 votes323 views1 answer
Python sql
SQL
2 votes283 views1 answer
Oracle drop sequence if exists
SQL
1 vote456 views1 answer
Postgres upgrade to superuser
SQL