Re: unique contraint without index

From: Taral <taral.desai_at_gmail.com>
Date: 16 Jan 2007 01:38:55 -0800
Message-ID: <1168940335.577728.235170@l53g2000cwa.googlegroups.com>

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);

On Jan 16, 12:07 pm, "oracle dba" <aoracle..._at_gmail.com> wrote:
> hi all,
> In my database I don't want any index on three columns (a,b and c) I
> need unique contraint on three columns, so that value will not repeat.
> Is it possible.
> And if no, then unique key is better or primary key for space usage
> prospective. Or if YES then pls tell me how.
Received on Tue Jan 16 2007 - 03:38:55 CST