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 vote120 views1 answer
Add alternate add column sql
SQL
2 votes111 views1 answer
Sqlite indexes
SQL
0 vote114 views1 answer
Cara menampilkan user di mysql terminal
SQL
2 votes118 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote107 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
42 votes138 views6 answers
Sql query duplicate rows
SQL
0 vote117 views1 answer
PSQL qith variables
SQL
1 vote126 views1 answer
Mysql login console
SQL
2 votes115 views1 answer
Oracle kill session by sql_id
SQL
0 vote119 views1 answer
Python mysql executemany
SQL