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

7 votes294 views6 answers
Nth highest salary in sql
SQL
3 votes299 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote335 views1 answer
Mysql workbench format date
SQL
1 vote293 views2 answers
Oracle list partitioned tables
SQL
0 vote288 views1 answer
Sql waitfor
SQL
0 vote285 views3 answers
Drop multiple columns in sql
SQL
8 votes279 views1 answer
Oracle find text in functions
SQL
0 vote296 views1 answer
Connect to ssms with python
SQL
1 vote294 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
2 votes298 views1 answer
Oracle drop sequence if exists
SQL