Check for existence of non unique index
Posted by: Stuart Fairful
Date: February 10, 2011 02:47PM

Is there any way to discover any non unique indices that a table might have from INFORMATION_SCHEMA? There is no row in TABLE_CONSTRAINTS or KEY_COLUMN_USAGE unless the index is unique. Non unique indices are listed by SHOW INDEX but I want to use the result programatically - specifically to create the index if it is not there.

Any ideas anyone?


Regards, Stuart Fairful

Options: ReplyQuote


Subject
Views
Written By
Posted
Check for existence of non unique index
7739
February 10, 2011 02:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.