15.10 - Example: Making Composite Changes to a Column: NULL to NOT 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

A composite change to a column implies changing more than one attribute of that column in one request. NULL columns can be changed to NOT NULL, along with other attribute changes, in one request. The following example changes both the case and NULL attribute of column_2. An error is returned if abc contains any rows with nulls in column_2.

     ALTER TABLE abc ADD column_2 CASESPECIFIC NOT NULL;