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 Mike Lewis 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
0
0
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
54
Beilstwh
Beilstwh
slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
64
taupirho
taupirho
yorge
  • Locked
  • Question
Return unique row from a given set of rows 2
Replies
3
Views
52
cmmrfrds
cmmrfrds
Andrzejek
  • Locked
  • Question
Table's ROWID as a PK/unique key 4
Replies
14
Views
177
SantaMufasa
SantaMufasa
pramsam1
  • Locked
  • Question
With Clause with UNIONS - how to enforce indexes
Replies
1
Views
75
LKBrwnDBA
LKBrwnDBA

Part and Inventory Search

Sponsor

Back
Top