Search found 1 match
- Fri Oct 02, 2015 1:28 am
- Forum: Vertica SQL
- Topic: Can we increase the identity column incremental value
- Replies: 1
- Views: 7144
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...