Teradata : Alter tables


Teradata : Alter tables

This tutorials will explain how to alter tables in Teradata. This alteration may not be limited to addition of new column, drop existing column or rename column.

Restrictions on altering a table
Table for Examples: Lets create below table for demonstrating alter commands.

CREATE TABLE teradataAlterTest
   pi INTEGER,
   order_id INTEGER,
   order_date DATE,
   cust_id DECIMAL(10),
   order_status VARCHAR(50)
)primary index(pi);

Various examples of altering tables in Teradata