Re: Why is database integrity so impopular ?

From: paul c <>
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

Original text of this message