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

8 votes310 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote368 views1 answer
Install mysql on bash
SQL
1 vote337 views1 answer
Mysql select from outside
SQL
0 vote310 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote375 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote366 views1 answer
Postgres docs /copy metacomand
SQL
0 vote324 views1 answer
Sql server roles and users
SQL
1 vote311 views1 answer
Postgres select as csv
SQL
0 vote312 views1 answer
Find wordpress version in database
SQL
0 vote313 views2 answers
Sqlite unique
SQL