Snowflake Tutorial: How to Drop Columns from Existing Tables
Learn how to effectively remove columns from existing tables in Snowflake with this comprehensive tutorial. Whether you're streamlining your database schema or removing obsolete data, discover the step-by-step process to seamlessly drop columns. Dive into practical examples and best practices for efficient data management in Snowflake.
Don't forget to like, share, and subscribe for more Snowflake tutorials!
#Snowflake #DatabaseManagement #ColumnRemoval #DataCleanup #SQL #DataManipulation #DatabaseSchema #TechTutorial #DataEngineering #CloudDataWarehouse #DataManagement
------------SQL--------------------
CREATE OR REPLACE TABLE employees (
employee_id INT,
first_name VARCHAR(50),
last_name VARCHAR(50),
salary NUMBER,
created_date date
);
-- Insert sample data into the employees table
INSERT INTO employees (employee_id, first_name, last_name, salary,created_date)
VALUES
(1001, 'John', 'Doe', 50000,current_date),
(1002, 'Jane', 'Smith', 60000,current_date),
(1003, 'Michael', 'Johnson', 75000,current_date),
(1004, 'Emily', 'Brown', 55000,current_date);
select * from employees;
ALTER TABLE employees
drop column salary;
ALTER TABLE employees DROP (CREATED_date) ;
SELECT * FROM employees;
ALTER TABLE employees DROP ( FIRST_NAME, LAST_NAME) ;
ALTER TABLE employees DROP column FIRST_NAME, LAST_NAME ;
select * from employees;
-------------------------------------------