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
Update sqlite
SQL
0 vote273 views1 answer
Sql filter rows with condition
SQL
0 vote195 views1 answer
Sql query for getting data with join and count
SQL
2 votes190 views1 answer
Drop table if exists in postgres
SQL
8 votes208 views1 answer
Script to add datafile to tablespace
SQL
0 vote224 views1 answer
TSQL function split string
SQL
0 vote252 views1 answer
Sql server rtrim everything after character
SQL
-1 vote317 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote201 views1 answer
Tsql cmd exec script from file
SQL
0 vote209 views1 answer
Sql #region
SQL