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 vote260 views1 answer
Sql server select value large text
SQL
14 votes256 views1 answer
Oracle new column
SQL
22 votes268 views3 answers
Remove all records from table mysql
SQL
1 vote241 views1 answer
Sql delete all values in a column
SQL
3 votes247 views2 answers
Sqlite show table definition
SQL
6 votes291 views2 answers
Mysql convert timestamp to date
SQL
1 vote256 views2 answers
T sql get foreign key
SQL
0 vote235 views1 answer
Oracle sql date summer time
SQL
1 vote281 views2 answers
Mysql extract number from string
SQL
-1 vote280 views3 answers
Error: mysql shutdown unexpectedly.
SQL