To store the data, every database uses rows and columns. Every row and column will have a particular name. Whenever we require, we can change the column name. This blog teaches you how to rename a column.
To rename the column in
Snowflake, we use the “ALTER TABLE … RENAME COLUMN” command.
Syntax:
alter table table_name1 rename column old_name1 to new_name1
Example
alter table products1 rename column products_category1 to products1;
“ALTER TABLE … RENAME COLUMN” command will rename the column as per our requirement. I hope this blog provides you with adequate information about that command.
Snowflake Related Articles
If you have any queries, let us know by commenting below.
Name | Dates | |
---|---|---|
Snowflake Training | Sep 21 to Oct 06 | View Details |
Snowflake Training | Sep 24 to Oct 09 | View Details |
Snowflake Training | Sep 28 to Oct 13 | View Details |
Snowflake Training | Oct 01 to Oct 16 | View Details |
Keerthi Sai is a Senior Writer at Mindmajix with tons of content creation experience in the areas of cloud computing, BI, Perl Scripting. She also creates content on Salesforce, Microstrategy, and Cobit.