Write a SQL query by hand
DB Explorer is designed to allow users to create or modify data using the graphical interface. You can, however, use DB Explorer to edit SQL queries you write by hand.
The following SQL commands are not supported:
- SQL commands that output information as text (for example, a command that shows a list of tables) will execute, however the text will not display.
- SQLite-specific commands (known as dot commands, such as .show) are not supported.
When you change or modify data using this tool, the changes are done under-the-covers by SQL statements. These SQL statements are governed by the rules of the database itself. The change needs to be valid by the rules of the database, in order for the query to run successfully.
You cannot use DB Explorer to view or edit binary data (BLOB data type). In addition, for some databases you cannot use DB Explorer to view or edit text-based large objects, such as the CLOB data type in IBM-Informix database servers.
Note: The Query Editor does not provide any language syntax assistance.