Working with SQL
You write and run SQL in SQL Commander. It has an SQL editor with auto completion and formatting, a graphical query builder, and tools for running scripts and finding errors.
When you run a script, DbVisualizer finds the statement delimiters, variables and client-side commands in it. Everything else is sent to the database as it is, so you can use any SQL that the database supports. The database type of the connection decides which keywords the editor recognizes and which objects you see. It is usually detected automatically, see Creating a Connection.
Writing SQL
- Choosing the Connection, Database and Schema
- Editing SQL Scripts
- Opening and Saving Scripts
- Formatting SQL
- Customizing the SQL Editor
- Using Editor Templates
- Using the Query Builder
- Comparing SQL Scripts
- Managing Frequently Used SQL
- Transforming Text Using Morph Selection
Executing SQL
- Executing SQL Statements
- Executing Complex Statements
- Executing a Script File
- Re-Executing SQL Statements
- Using Variables and Parameter Markers
- Setting SQL Permissions
Results and logs
- Using the Log Tab
- Locating SQL Errors
- Using the DBMS Output Tab
- Analyzing Query Performance (Explain Plan)