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
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:
Name | Dates | |
---|---|---|
Snowflake Training | May 10 to May 25 | View Details |
Snowflake Training | May 13 to May 28 | View Details |
Snowflake Training | May 17 to Jun 01 | View Details |
Snowflake Training | May 20 to Jun 04 | View Details |
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