How to Drop a Column in Snowflake

In tables, we will have rows and columns to store the data in order. When we don’t require some data, we can delete that data. To delete that data, we have to delete those columns. This blog teaches you to drop a single column or multiple columns.

Rating: 4.5
996
Get Trained And Certified

Drop a Column in Snowflake

In Snowflake, we can drop the columns through the “ALTER TABLE .. DROP COLUMN” command.

Dropping one column:

alter table product1
drop column description1;

Dropping multiple columns:

alter table product1
drop column price1, description1;
Looking forward to a career in a cloud data warehousing domain? Check out the "Snowflake Training" and get certified today

MindMajix Youtube Channel

Conclusion

Drop command is one of the essential commands in a Database. It helps delete particular rows or columns or complete data. I hope this article provides you with sufficient information about dropping a column.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop
▶  Snowflake Time Travel
Course Schedule
NameDates
Snowflake TrainingOct 19 to Nov 03View Details
Snowflake TrainingOct 22 to Nov 06View Details
Snowflake TrainingOct 26 to Nov 10View Details
Snowflake TrainingOct 29 to Nov 13View Details
Last updated: 04 Apr 2023
About Author
Remy Sharp
Viswanath V S

Viswanath is a passionate content writer of Mindmajix. He has expertise in Trending Domains like Data Science, Artificial Intelligence, Machine Learning, Blockchain, etc. His articles help the learners to get insights about the Domain. You can reach him on Linkedin

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