Re: Difference between Unique Constraint & Unique Index

From: <johnvue_at_gte.net>
Date: Wed, 02 Sep 1998 14:02:31 GMT
Message-ID: <6sjj5n$iiv$1@nnrp1.dejanews.com>

From a functional/operational standpoint, they're the same.

However, Oracle has deprecated the command "CREATE UNIQUE INDEX ...". In other words, even though the syntax still works, Oracle wants you to ignore it as if it wasn't there.

In article <6sivhl$70f$1_at_news2.isdnet.net>, "Gilles FLORENTIN" <gflorentin_at_hol.fr> wrote:
> Hi,
>
> What's the difference between unique constraints and unique indexes.
>
> Thank's

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 02 1998 - 09:02:31 CDT