Create an INSERT statement

You use an INSERT statement to specify criteria for inserting a single row of data into an existing database table.

In some environments, you cannot use SQL Assist to create INSERT statements.

To create an INSERT statement:

  1. In the Outline view, click the main SQL Statement Properties node.
  2. In the Details area, click INSERT. An INSERT statement outline is displayed in the Outline view.
  3. Select a table to insert data into (INSERT INTO clause).
  4. Specify data to insert into the table (VALUES clause).
  5. Click OK. The SQL Assist window closes, and the generated SQL code is sent to the client application.

Related tasks

Add expressions
Create a SELECT statement
Create an UPDATE statement
Create a DELETE statement
Edit an SQL statement
Check SQL syntax
Run an SQL statement