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
1107
Get Trained And Certified

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 Youtube Channel

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. 

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
Snowflake TrainingJan 25 to Feb 09View Details
Snowflake TrainingJan 28 to Feb 12View Details
Snowflake TrainingFeb 01 to Feb 16View Details
Snowflake TrainingFeb 04 to Feb 19View Details
Last updated: 04 Apr 2023
About Author
Remy Sharp
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.

read less
Recommended Courses
1 / 10
  1. Share:
Snowflake Articles
Snowflake Quiz