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 vote142 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote159 views2 answers
Remove space in mysql
SQL
0 vote129 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
1 vote139 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote133 views1 answer
Close sql query vb.net
SQL
3 votes176 views1 answer
Oracle nextval insert
SQL
0 vote153 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote134 views1 answer
Restore backupfile discourse
SQL
4 votes137 views6 answers
Sql select statement
SQL
0 vote127 views1 answer
Knex last insert id mysql
SQL