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 vote217 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote191 views1 answer
Psql connect to another database
SQL
9 votes218 views1 answer
No sql
SQL
3 votes159 views2 answers
Pl sql escape '
SQL
4 votes238 views2 answers
Mysql alter table set column unique
SQL
0 vote166 views1 answer
Cast for print sql
SQL
0 vote242 views1 answer
Sql database size
SQL
2 votes170 views1 answer
Plsql left() function
SQL
-1 vote128 views2 answers
On delete set default sql server
SQL
4 votes161 views2 answers
Postgresql reset sequence
SQL