SQL Communications
SQL commands can be executed directly on a database server using DbWrench. A valid connection must be defined for the server.
Executing SQL:
On the Tools menu, click Sql Communicator.
In the Sql Communicator window that appears, select the appropriate server connection in the combo box found in this window's toolbar.
In the text panel, type a valid SQL query or command.
Press F5.
The result of the SQL command should be displayed in the grid in the lower half of this window.
Useful Hints:
Multiple commands can be sent at once, by seperating each command with a semi-colon.
A subset of commands can executed by selecting or high lighting only those commands to be sent.
Data results grid and editor settings can be customized using the Preferences panel.
To prevent excessive use of resources the number of commands that can be sent to a database server at one time is limited to 25.
See also: