Snowflake – Add, Drop, or Modify Column In Snowflake Table

In order to add additional columns to your Snowflake tables, or get rid of few of the obsolete tables, Snowflake allows us to modify the table using the ALTER Command.

ALTER TABLE MY_TABLE ADD COLUMN NEW_COLUMN VARCHAR(100);

to drop a column,

ALTER TABLE MY_TABLE DROP COLUMN NEW_COLUMN VARCHAR(100);

to modify a column,

ALTER TABLE MY_TABLE MODIFY COLUMN NEW_COLUMN VARCHAR(100);