SQL Statements › INSERT › Rules for Inserting

Rules for Inserting

Insert values must satisfy the following rules:

Default values:

The value inserted in any column not in the column list is the default value of the column. Columns without a default value must be included in the column list.

If you insert into a view, the default value is inserted into any column of the base table that is not included in the view.

All columns of the base table that are not in the view must have default values.

Length:

If the insert value of a column is a number, the column must be a numeric column with the capacity to represent the integral part of the number.

If the insert value of a column is a string, the column must be a string column with a length attribute at least as great as the length of the string.

If insert values do not adhere to the previously given rules, or if any other error occurs during the execution of the INSERT statement, no rows are inserted.