Specify data to insert into a table (VALUES clause)
These steps are part of the larger task of creating an INSERT statement. When you complete the steps for specifying data to insert into a table, return to Create an INSERT
statement.
To specify data to insert into a table:
- In the Outline view, click the VALUES (Row values) node. A list of
columns in the table that you selected in the previous step is displayed in
the Details area. The names and data types of the columns are also
listed.
- In the Value column, specify values to insert. You can:
- Type a value.
- Click NULL or DEFAULT.
- Click Expression to open a window
where you can create an expression.
- Click List Values to open a window
where you can view a list of existing values for the selected column.
Blank column values are omitted from the insert list.
Return to Create an INSERT statement.