How to Remove a Default Value to a Column in Snowflake

To remove a default value to a column in Snowflake, use the ALTER TABLE <table_name> ALTER <column_name> DROP DEFAULT command:

alter table products
alter id
drop default;
database icon
Shared queries and folders ✅ Version history ✅ One-click connection to Snowflake ✅
Get more done, together, with PopSQL and Snowflake