Re: to add table with primary key
Date: Thu, 28 Feb 2008 14:24:40 +0100
"codadilupo" <yossarian99_at_operamail.com> schreef in bericht
> Bumsys_at_gmail.com wrote:
>> create sequence au_clients_seq start with 1 increment by 1
>> i want that primary fey start with 0. what can do in this case?
> create sequence au_clients_seq start with 0 MINVALUE 0 increment by 1
This will not guarantee that your key will actually start with 0. If you insert the first record, but do not commit (rollback), 0 will be missing. Of course you can (and I guess you will) insert the first record yourself, [Quoted] but I often wonder why people use sequences and want to keep control of the values.
Shakespeare Received on Thu Feb 28 2008 - 14:24:40 CET