> > if I create a table like this:
> > CREATE TABLE test (
> > id decimal(3) primary key,
> > name varchar(32));
<snip>
> Note that this makes the assumption that only one field can be in the
> primary key (no complex primary keys) but I don't think there will
> ever be more than one the way we declare it now.
fyi, the following syntax is allowed:
CREATE TABLE test ( id decimal(3), name varchar(32), primary key(id));
and multiple columns can be declared as primary keys.
- Tom