Systematic Use of Default Values - Teradata Vantage - Analytics Database

Database Design

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ogg1628096130566.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zqc1472244571611
lifecycle
lifecycle
Product Category
Teradata Vantage™

Because SQL has a built-in, nonprocedural, method to handle default values (see the default value control phrases DEFAULT and WITH DEFAULT in Teradata Vantage™ - Data Types and Literals, B035-1143), 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.