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 vote111 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote138 views1 answer
Plpgsql create function
SQL
0 vote81 views1 answer
Mariadb list tables
SQL
1 vote120 views1 answer
Raw query must include primary key
SQL
0 vote119 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote69 views1 answer
Alter session set nls_language french
SQL
0 vote118 views3 answers
Select random sql
SQL
1 vote108 views1 answer
Oracle rolling back
SQL
1 vote108 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
1 vote113 views1 answer
Sql into vs insert into
SQL