Skip to content

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

Executing SQL

Results and logs

Client-side commands