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. |