How to Drop a Column in Snowflake

Dropping a column in Snowflake involves using the ALTER TABLE .. DROP COLUMN command.

Drop one column:

alter table products
drop column description;

Drop multiple columns at the same time:

alter table products
drop column price, description;
database icon
Real-time SQL collaboration is here
Get started with PopSQL and Snowflake in minutes