16.10 - Systematic Use of Default Values - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Release Date
June 2017
Content Type
User Guide
Publication ID
English (United States)

Because SQL has a built-in, nonprocedural, method to handle default values (see the default value control phrases “DEFAULT” and “WITH DEFAULT” in SQL Data Types and Literals), no special coding is required on the part of users. Note that if no defaults are specified for a column and it is not defined as NOT NULL, then SQL automatically inserts nulls to represent any information missing from an INSERT request.