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:
- In the Outline view, click the main SQL Statement Properties
node.
- In the Details area, click INSERT. An INSERT statement outline is displayed in the Outline view.
- Select a table to insert data into (INSERT INTO clause).
- Specify data to insert into the table (VALUES clause).
- 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