Snowflake Tutorial: How to Modify Existing Columns in a Table
Learn how to efficiently modify existing columns within a table in Snowflake with this step-by-step tutorial. Whether you're updating data types or altering column names, discover the process to seamlessly modify your database schema. Dive into practical examples and best practices for smooth data management in Snowflake.
Don't forget to like, share, and subscribe for more Snowflake tutorials!
#Snowflake #DatabaseManagement #DataManipulation #SQL #DataTypes #DataModeling #DatabaseSchema #TechTutorial #DataEngineering #CloudDataWarehouse #datamanagement
----------------------------
sql query--
-----------------
-- HOW TO MODIFY EXISTING COLUMN IN TABLE
-- Create the employees table with the 'salary' column
CREATE OR REPLACE TABLE employees (
employee_id INT,
first_name VARCHAR(50),
last_name VARCHAR(50),
salary NUMBER
);
-- Insert sample data into the employees table
INSERT INTO employees (employee_id, first_name, last_name, salary)
VALUES
(1001, 'John', 'Doe', 50000),
(1002, 'Jane', 'Smith', 60000),
(1003, 'Michael', 'Johnson', 75000),
(1004, 'Emily', 'Brown', 55000);
DESC TABLE EMPLOYEES;
SELECT * FROM employees;
DESC TABLE EMPLOYEES;
ALTER TABLE employees
MODIFY (first_name VARCHAR(200) );
ALTER TABLE employees
alter column first_name VARCHAR(300) ;
ALTER TABLE employees
MODIFY (first_name VARCHAR(50) );
select * from employees;
ALTER TABLE employees
MODIFY (first_name not null );
select * from employees;
ALTER TABLE employees
MODIFY (first_name NUMBER );
ALTER TABLE employees
MODIFY (salary VARCHAR(11) );
ALTER TABLE employees
MODIFY (first_name CHAR(1000) );
ALTER TABLE employees
MODIFY (first_name VARCHAR(2000) );
ALTER TABLE EMPLOYEES ADD (CREATED_DATE DATE);
ALTER TABLE employees
MODIFY (CREATED_DATE VARCHAR(8) );