disable/remove auto increment attribute in snowflake

user_17394143 0
Viewed 317

the table i used is ,

create or replace table abc(id int autoincrement, name varchar,date_of_birth date, age number, ts timestamp_ntz);

I used the below query to remove auto increment attribute in snowflake

alter table abc modify id int

here i have redefined the column name without the auto increment attribute . it works fine in mysql workbench but it is not working in snowflake . is there is some other way to disable/remove auto increment attribute in snowflake?

snowflake-cloud-data-platform alter auto-increment
1 Answers

"Drop default" is doing the trick:

alter table abc alter id drop default;
user_124804310
Related