How to Remove a NOT NULL Constraint in Snowflake

To remove a NOT NULL constraint for a column in Snowflake, you use the ALTER TABLE <table_name> ALTER <column_name> DROP command and restate the column definition, adding the NOT NULL attribute.

alter table products
alter category drop not null;
Cta

Shared queries and folders ✅ Version history ✅ One-click connection to Snowflake ✅

Get more done, together, with PopSQL and Snowflake