Home » SQL & PL/SQL » SQL & PL/SQL » To find the Unique Indexes
To find the Unique Indexes [message #302832] Wed, 27 February 2008 02:18 Go to next message
Messages: 40
Registered: June 2007
Location: India
Hi Team ,

Is there a way to find the unique index in a table .
DO we have any table which store the unique indexes ofa table ?

Thanks &Regards
Re: To find the Unique Indexes [message #302836 is a reply to message #302832] Wed, 27 February 2008 02:27 Go to previous message
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Check USER_INDEXES (or ALL_ or DBA_) , you'll find a column named UNIQUENESS

EDIT: But it depends on your database-version

[Updated on: Wed, 27 February 2008 02:28]

Report message to a moderator

Previous Topic: WITH Clause
Next Topic: An update statement required
Goto Forum:

Current Time: Sat Aug 19 11:58:39 CDT 2017

Total time taken to generate the page: 0.15099 seconds