16.10 - Systematic Use of Default Values - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
User Guide
Publication ID
B035-1094-161K
Language
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.