How to Remove a NOT NULL Constraint in Snowflake 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;

Ready for a modern SQL editor?