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 vote290 views1 answer
Will graphql replace sql
SQL
51 votes380 views6 answers
Change column name sql
SQL
1 vote263 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
1 vote249 views1 answer
Can we drop a primary key
SQL
0 vote297 views1 answer
GROUP BY postgres
SQL
0 vote264 views1 answer
Mysql wsrep ls
SQL
0 vote311 views1 answer
Error code 1451 sql
SQL
2 votes269 views2 answers
Change mysql password from command line
SQL
0 vote274 views1 answer
Oracle temporary table
SQL
0 vote268 views1 answer
Restore backupfile discourse
SQL