Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to Check to see what Columns are Indexed on Table

The relevant query is as follows:

SELECT column_name, index_name
FROM     all_ind_columns
WHERE  table_name = ‘<TABLE_NAME>’;

U = unique index
N = non-unique index
Share this article :

0 comments:

Post a Comment