DEFAULT Phrase | Data Types and Literals | VantageCloud Lake - DEFAULT Phrase - Teradata VantageCloud Lake

Specifies that a user-defined default value is to be inserted in the field when a value is not specified for a column in an INSERT statement.

• DEFAULT Phrase Syntax
• DEFAULT Phrase Usage Notes
• DEFAULT Phrase Examples

ANSI Compliance

DEFAULT is ANSI SQL:2011 compliant.

Also see the non-ANSI WITH DEFAULT Phrase.