Search found 1 match

by abdel.david1
Fri Oct 02, 2015 1:28 am
Forum: Vertica SQL
Topic: Can we increase the identity column incremental value
Replies: 1
Views: 2965

Can we increase the identity column incremental value

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...

Go to advanced search