15.00 - Systematic Use of Default Values - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Systematic Use of Default Values

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.