Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Adding column in a table in Teradata

The ADD function has options for the new column name, data type, the size and the scale of the new type, whether or not the new column should allow null values, and whether or not the new column has a default value associated with it.

Syntax:
  1. ALTER TABLE tbl_name ADD column_name datatype


Examples:
  1. ALTER TABLE tbl_employee ADD native_place CHAR(25) ;

  1. ALTER TABLE tbl_employee ADD native_place CHAR(25) DEFAULT 'Mumbai' ;

  1. ALTER TABLE tbl_employee ADD native_place CHAR(25) NOT NULL;