Re: Why is database integrity so impopular ?
From: paul c <toledobythesea_at_oohay.ac>
Date: Tue, 14 Oct 2008 05:16:34 GMT
Message-ID: <SWVIk.1429$fF3.1368_at_edtnps83>
>
> It is considered a deviation not to have a default? Why is that? I would
> have thought that having defaults for every column would encourage
> sloppiness.
Date: Tue, 14 Oct 2008 05:16:34 GMT
Message-ID: <SWVIk.1429$fF3.1368_at_edtnps83>
Jon Heggland wrote:
> DBMS_Plumber wrote:
>> Later, over a cocktail or two, we chatted. In his shop EVERY table >> has a declared primary key, every column without NOT NULL and DEFAULT >> must have a documented reason for the deviation.
>
> It is considered a deviation not to have a default? Why is that? I would
> have thought that having defaults for every column would encourage
> sloppiness.
When it comes to "every column", no argument, but isn't what SQL calls a DEFAULT really just a special form of constraint? Received on Tue Oct 14 2008 - 07:16:34 CEST