Hi!
I have a question about unique keys:
When I issue the statement
CREATE UNIQUE INDEX UK_TBDOCUMENT ON TBDOCUMENT(DOCUMENTID)
Oracle creates a unique index (as in user_indexes) but no unique constraint
(as in user_constraints)
When I issue that statement in a create table statement
create table....
CONSTRAINT UK_TBDOCUMENT
UNIQUE (DOCUMENTID)
Oracle creates a unique constraint plus an index.
Why is Oracle doing this? Could somebody please shed some light on this?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).