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 vote189 views1 answer
Postgres set column based on another column
SQL
0 vote114 views1 answer
Wordpress sql change site url
SQL
0 vote114 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote116 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
16 votes107 views2 answers
Add column to all tables after first column mysql
SQL
1 vote57 views1 answer
Oracle character set
SQL
2 votes99 views2 answers
Oracle create table if not exists
SQL
0 vote117 views1 answer
Sql include rows with 0 values
SQL
1 vote116 views1 answer
Flask sqlalchemy default value
SQL
1 vote113 views1 answer
Drop function
SQL