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:

  1. 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.
  2. In the Value column, specify values to insert. You can: Blank column values are omitted from the insert list.

Return to Create an INSERT statement.