About SQL Explorer

SQL Explorer allows to quickly browse database and table structure.

To enable SQL Explorer, on the View menu click SQL Explorer.

To add a database connection, click Add Database Connection toolbar button. When your database connection is added, you can connect by double-clicking its icon.

You can drag database name, table name or field name directly into your code. Holding down Shift key while dragging field name will insert both the field and the table name table.field.

To browse table data or execute SQL statement, select a database or table and click SQL Browser toolbar button.

Notes

  • Currently supported are MySQL, PostgreSQL and Firebird SQL databases.
  • For this feature to work, you may have to install specific database drivers. Click here for more info.