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||Dec 05 to Dec 20||View Details|
|Snowflake Training||Dec 09 to Dec 24||View Details|
|Snowflake Training||Dec 12 to Dec 27||View Details|
|Snowflake Training||Dec 16 to Dec 31||View Details|
Copyright © 2013 - 2023 MindMajix Technologies