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
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
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
Binu
Re: To find the Unique Indexes [message #302836 is a reply to message #302832] Wed, 27 February 2008 02:27 Go to previous message
MarcS
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: sql
Next Topic: An update statement required
Goto Forum:
  


Current Time: Fri Dec 09 03:51:36 CST 2016

Total time taken to generate the page: 0.13193 seconds