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');
You can use the following query to RENAME THE COLUMN Name
to Sign
ALTER TABLE Schools
RENAME COLUMN Name TO Sign;