Using INSERT … SELECT With a DEFAULT Function - Teradata Database

Using INSERT … SELECT With a DEFAULT Function

The following rules apply when using a DEFAULT function to load a table using an INSERT … SELECT operation:

All of the rules listed for “DEFAULT Function in SELECT Statements” on page 18 also hold for the SELECT subquery in an INSERT … SELECT request.

The DEFAULT function cannot be specified without a column name as its argument within the SELECT subquery of an INSERT … SELECT request.

For more information about the DEFAULT function, see SQL Functions, Operators, Expressions, and Predicates.