From: "Jan Gelbrich" <j_gelbrich@westfalen-blatt.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: constraint question
Date: Mon, 9 Sep 2002 08:54:35 +0200
Lines: 16
Message-ID: <alhgpe$1opmef$1@ID-152732.news.dfncis.de>
References: <alfu81$3vd$1@newsreader.mailgate.org> <uno9qpk0alj55a@corp.supernews.com> <alhbip$pok$1@newsreader.mailgate.org>
NNTP-Posting-Host: gateway.westfalen-blatt.de (195.177.181.10)
X-Trace: fu-berlin.de 1031554670 59562447 195.177.181.10 (16 [152732])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700



"eugene kim" <eugene1977@hotmail.com> schrieb im Newsbeitrag
news:alhbip$pok$1@newsreader.mailgate.org...
> thanks for helps..
>
> but then
> is it a good idea to have unique constraint for all columns for each table
>
It just depends how You want to design the data model.
An all-column unique constraint would only be necessary if You really want
_all combinations_ to be unique.
Is this the case ?

Jan