Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: unique contraint without index

Re: unique contraint without index

From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Tue, 16 Jan 2007 10:00:17 +0000
Message-ID: <45aca231$0$8743$ed2619ec@ptn-nntp-reader02.plus.net>


Taral wrote:
> Yes, you can create unique constraint on this two column and will not
> create unique index
>
> ALTER TABLE table_name
> add CONSTRAINT constraint_name UNIQUE (column1, column2, ... column_n);
>

How does Oracle implement constraints? :-)

   BugBear Received on Tue Jan 16 2007 - 04:00:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US