VALUES Clause - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

VALUES Clause

 

Syntax element …

Specifies …

expression

the non‑default set of values to be inserted into table_name_2.

Note that you must specify values or nulls for each column defined for the table named table_name_2 or the insert fails.

DEFAULT

 

DEFAULT (column_name)

that the DEFAULT function should update the column with its default value in the position by which it is called in the expression list.

If you specify DEFAULT (column_name), then the DEFAULT function updates the default value for the column specified by column_name, and the position of the DEFAULT call in the expression list is ignored.

column_name

the column set into which the values specified by expression are to be inserted.

DEFAULT VALUES

that a row consisting of default values is to be added to table_name.

If any column does not have a defined DEFAULT phrase, then the process inserts a null for that column.