Snowflake snippets

How to rename a column in Snowflake

Let's suppose you have the following Schools table.

CREATE TABLE Schools(
Name varchar(250),
Grade varchar(150),
City varchar(150));
INSERT INTO
Schools(Name,Grade,City)
VALUES
('Astro School', 'Specialization school', 'Huston'),
('The white beach school', 'High School', 'Honolulu'),
('Queen High School', 'High School', 'London');

Snowflake snippet 6

You can use the following query to RENAME THE COLUMN Name to Sign

ALTER TABLE Schools
  RENAME COLUMN Name TO Sign;
Snowflake snippet 7

Back to Snowflake cookbook page