SQL Console

JMap Admin provides a generic SQL console that can be used to view database structures, execute SQL queries, inspect the content of tables, test for query execution speed, etc.

All configured databases are accessible through this console.

When performing an SQL query, the query execution is subject to security permissions granted to the user connected to the database. See Creating Databases section for more information about specifying the user for database connections.

SQL console
Database	Select the database to use.
View structure	Click on to open a window that allows you to navigate in the structure of the database. You can see the schemas, the tables and views, and information about each field of a table or view.
Max. rows	When executing a SELECT SQL query, you can enter a value to limit the number of returned rows.
Auto commit	If performing SQL transactions (e.g. INSERT, UPDATE), select this option to validate the transactions automatically (SQL COMMIT command). Otherwise, you will need to perform the validations manually.
Test for speed only	When executing an SQL query, select this option to repeat the query a certain number of times and display the execution times.
SQL Query	Enter the SQL query to execute. The result will be displayed in a table.

Query results are displayed in a new window. The results of the INSERT, UPDATE, and DELETE requests are grouped in the same tab. The results of SELECT type queries appear in separate tabs.