Re: Auto Increment

On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu"
<mayureshk(at)aftek(dot)com> wrote:

>hi all,
>
>could anyone tell me how to make a primary key to AUTO INCREMENT. The
>document is not exactly very explainatory about it :)
>
>Thankx in advance ...
>
>
>
>Mayuresh
>
>

Try first creating a sequence and then using the sequence as a default
value in your table:

-- STEP 1: create sequence
create sequence mytableid_seq;

-- STEP 2: create table
create table mytable (
id int default nextval ('mytableid_seq'),
anyvalue varchar
primary key (id));