20 October 2018        Add to Favorites   Report

Add, remove or modify a column - ALTER TABLE in  Snowflake

Data warehouse evolves with the ever-growing business needs. We often have to add additional columns to our warehouse tables, or get rid of few of the obsolete ones, etc... Snowflake lets the users modify the table using the ALTER Command.

ALTER TABLE EMPLOYEE ADD COLUMN FIRST_NAME VARCHAR(100);

to drop a column,

ALTER TABLE EMPLOYEE DROP COLUMN FIRST_NAME VARCHAR(100);

to modify a column,

ALTER TABLE EMPLOYEE MODIFY COLUMN FIRST_NAME VARCHAR(200)



Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied