How to Rename a Column in Snowflake

Renaming a column in Snowflake involves using the ALTER TABLE .. RENAME COLUMN command.

-- syntax
alter table table_name rename column old_name to new_name;

-- rename product_category column in products table
alter table products rename column products_category to products;
database icon
Finally, a unified workspace for your SQL development
Get more done, together, with PopSQL and Snowflake