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 vote357 views2 answers
Get top 1 row of each group
SQL
51 votes458 views6 answers
Change column name sql
SQL
0 vote369 views1 answer
Mysql zerofill
SQL
1 vote337 views1 answer
Set mysql mode global query
SQL
1 vote373 views3 answers
Rename table snowflake
SQL
7 votes378 views3 answers
Convert ansi sql
SQL
10 votes371 views4 answers
Primary key in sql
SQL
13 votes348 views5 answers
Select last row mysql
SQL
1 vote347 views1 answer
Sql delete row with auto increment
SQL
0 vote345 views1 answer
Criteria builder select subset of column
SQL