Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DD Unique Index

Status
Not open for further replies.
Thiko

Thiko

Programmer
Mar 9, 2001
49
GB
Which Data Dictionary will tell you whether there are any unique indexes created in your database?

Created with a Create Unique index..... not an alter table add primary key statement.....

Many Thanks.

Thiko!
 
Sort by date Sort by votes
The view DBA_INDEXES contains descriptions for all indexes in the database. The field UNIQUENESS contains the status of the index: UNIQUE or NONUNIQUE

hope this was wat you meant..
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kernal
  • Locked
  • Question
Change DATE and also a TIMESTAMP to just a date as 'MM/DD/YYYY. Also, need dummy date when null 1
Replies
2
Views
90
Beilstwh
Beilstwh
slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
97
taupirho
taupirho
yorge
  • Locked
  • Question
Return unique row from a given set of rows 2
Replies
3
Views
97
cmmrfrds
cmmrfrds
Andrzejek
  • Locked
  • Question
Table's ROWID as a PK/unique key 4
Replies
14
Views
343
SantaMufasa
SantaMufasa
pramsam1
  • Locked
  • Question
With Clause with UNIONS - how to enforce indexes
Replies
1
Views
158
LKBrwnDBA
LKBrwnDBA

Part and Inventory Search

Sponsor

Back
Top