In message <a264e7ea.0308081156.4cd72b48_at_posting.google.com>, --CELKO--
<joe.celko_at_northface.edu> writes
>CREATE TABLE Rate_Revisions
>(rate_name VARCHAR(20) DEFAULT ‘{{unknown}}'
> NOT NULL PRIMARY KEY,
Nitpick: primary key's can't be null, for good reason. Substituting a
default value doesn't improve the situation. It would be better for an
insert without a valid key to fail than to have even one record with an
unknown key.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.
Received on Mon Aug 11 2003 - 18:54:50 CDT
