RE: [SQL] primary key question

2000-07-25 Thread Pablo Niklas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 El 20-Jul-2000 Carolyn Lu Wong escribio: > create table aaa( > field1 not null, > field2 , > , > primary key (field1, field2) > ); > > Based on the above table definition, field2 allows null values. But > after

Re: [SQL] primary key question

2000-07-20 Thread omid omoomi
>From: Carolyn Lu Wong <[EMAIL PROTECTED]> >To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> >Subject: [SQL] primary key question >Date: Thu, 20 Jul 2000 17:26:30 +1000 > >create table aaa( > field1 not null, > field2 , >

Re: [SQL] primary key question

2000-07-20 Thread Wim Ceulemans
Carolyn Lu Wong wrote: > > create table aaa( > field1 not null, > field2 , > , > primary key (field1, field2) > ); > > Based on the above table definition, field2 allows null values. But > after the table created based on the above script, field2 be

[SQL] primary key question

2000-07-20 Thread Carolyn Lu Wong
create table aaa( field1 not null, field2 , , primary key (field1, field2) ); Based on the above table definition, field2 allows null values. But after the table created based on the above script, field2 becomes not null. The only conclusion I come u