SQL builder for INSERT statements

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 <.
Related tasks
Specifying INSERT statements in the SQL builder

Feedback