Adding column to a table in Teradata
To add a new column to an existing table i n Teradata without dropping it, we can make use of the alter table command
ALTER TABLE Table_name ADD column_name datatype
ALTER TABLE HAPPY_EMPLOYEES ADD HOBBIES VARCHAR(255) ;
ALTER TABLE HAPPY_EMPLOYEES ADD HOBBIES VARCHAR(255) NOT NULL DEFAULT 'DAY DREAMING';
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too