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.
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|
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
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Snowflake Training||Jun 03 to Jun 18|
|Snowflake Training||Jun 06 to Jun 21|
|Snowflake Training||Jun 10 to Jun 25|
|Snowflake Training||Jun 13 to Jun 28|
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
Copyright © 2013 - 2023 MindMajix Technologies