Can we increase the identity column incremental value

Moderator: NorbertKrupa

Post Reply
abdel.david1
Newbie
Newbie
Posts: 1
Joined: Sat Jul 11, 2015 7:13 am

Can we increase the identity column incremental value

Post by abdel.david1 » Fri Oct 02, 2015 1:28 am

CREATE TABLE t1(x IDENTITY(1) ,y INT)

Is there a way to change the identity column incremental value from 1 to say 10000.

I create the above table now I increment the identity column x IDENTITY(1) to x IDENTITY(10000)

I tried below sql but it does not work

alter table t1 alter column x SET DATA TYPE IDENTITY ( 10000 );

Can anyone help

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Can we increase the identity column incremental value

Post by NorbertKrupa » Fri Oct 02, 2015 3:32 am

See my answer on StackOverflow.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica SQL”