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.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
Snowflake Training | Apr 20 to May 05 | View Details |
Snowflake Training | Apr 23 to May 08 | View Details |
Snowflake Training | Apr 27 to May 12 | View Details |
Snowflake Training | Apr 30 to May 15 | 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.
1 / 10
Copyright © 2013 - 2024 MindMajix Technologies