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 vote269 views1 answer
Create query in where clasue
SQL
4 votes273 views2 answers
Show all database inside postgresql
SQL
0 vote253 views1 answer
Can we rollback deleted data in sql
SQL
0 vote308 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote265 views1 answer
Restart sql server command line linux
SQL
0 vote255 views1 answer
Sub blocks in sql
SQL
0 vote258 views1 answer
Equi joins in oracle
SQL
0 vote247 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote277 views1 answer
Change filed order in mysql
SQL
5 votes285 views3 answers
Sql server utc to local
SQL