The SQL statements that appear in the SQL Editor can be executed against the database, with immediate effect. The result of the SQL query and the number of affected rows is displayed in the Messages pane of the DB Query pane.
When multiple SQL statements appear in the SQL Editor, only the selected statements will be executed. You can select individual SQL statements as follows:
•Holding the left mouse button clicked, drag the cursor over a specific statement.
•Click a line number in the SQL Editor.
•Triple-click a specific statement.
To execute a SQL statement:
1.Enter or select the SQL statement in the SQL Editor (see Generating SQL Statements ).
2.Click the Execute ( ) button.