Home  >  Blog  >   Snowflake  > 

How to Rename a Column in Snowflake

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.

Rating: 4
  
 
243
  1. Share:
Snowflake Articles

Rename a Column in Snowflake

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;
MindMajix Logo

Subscribe to explore the latest tech updates, career transformation tips, and much more.

Conclusion

“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


▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop
▶  Snowflake Time Travel

If you have any queries, let us know by commenting below. 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingDec 10 to Dec 25
Snowflake TrainingDec 13 to Dec 28
Snowflake TrainingDec 17 to Jan 01
Snowflake TrainingDec 20 to Jan 04
Last updated: 08 December 2022
About Author
Keerthi Sai

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.