Am 21.05.2010 03:46, schrieb Adrian Klaver:
> You know serial is just a shortcut for:
>
> pid int NOT NULL DEFAULT nextval('seq')
>
> I think you will find Access will place nice if you use the long form to define
> your autoincrement.
>
Not true. Serial will also add an internal dependency between the
sequence, will create the sequence and will drop everything if the
column gets dropped.
Regards,
Daniel Migowski