15.10 - Example: Making Composite Changes to a Column: NOT NULL to NULL - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Composite changes to columns that involve changing the NOT NULL attribute to NULL are not valid. For example, the following cannot be done:

     ALTER TABLE abc ADD column_2 TITLE 'newname' NULL;

To make these changes, you must perform two separate ALTER TABLE requests:

     ALTER TABLE abc ADD column_2 TITLE 'newname';
     ALTER TABLE abc ADD column_2 NULL;