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;
Shared queries and folders ✅ Version history ✅ One-click connection to Snowflake ✅
Get more done, together, with PopSQL and Snowflake