Use the panes in the SQL builder to create an INSERT statement.
An INSERT statement inserts rows into a database table by using
either the values that you specify or a subquery.
- SQL Source pane
- Use this pane to review the INSERT statement as
you build the statement in the Tables pane and the Design pane. You can
also type changes directly in this pane. If you change the statement in this
pane, you can parse the statement by moving the focus out of the pane or by
saving the statement. If the parser considers the statement syntax valid,
the Tables and Design pane are synchronized to reflect the updated statement.
- Tables pane
- Use this pane to add a table to the INSERT statement.
You can also select columns in this pane. After you add a table, to add
columns to the INSERT statement, select their check boxes in the table graphic.
- Design pane
- Use the fields and pages in this pane to define
elements in the INSERT statement.
- Statement
- The name of the INSERT statement.
- Values
- Select this option to specify values for the columns
in the table that you selected in the Tables pane. When you select this
option, the pane displays a grid with Column and Value columns.
- Column
- Select the column for which you want to specify a value.
- Value
- Specify the value for the column.
- Subquery
- Select this option to insert rows from a subquery. When
you select this option, the Query name field is available, and the
pane displays information about the available and selected columns.
- Query name
- Select an existing query, or select the type of
subquery that you want to create in the INSERT statement: SELECT, FULLSELECT,
or WITH.
- unlabeled box
- Lists the columns that have not been
selected for the INSERT statement. To select a column, click it in this
list, and then click >.
- Column
- Lists the columns that have been selected for
the INSERT statement. To remove a column from this list, click it and
then click <.