# 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. 

{% hint style="info" %}
All configured databases are accessible through this console.
{% endhint %}

When performing an SQL query, the query execution is subject to security permissions granted to the user connected to the database. See [Creating Databases](https://docs-jmapserver-lima.k2geospatial.com/e/administrator/jmap-server-administrator-manual/resources-databases/creating-databases) section for more information about specifying the user for database connections.

<table data-header-hidden><thead><tr><th width="174"></th><th></th></tr></thead><tbody><tr><td><strong>SQL console</strong></td><td> </td></tr><tr><td>Database</td><td>Select the database to use.</td></tr><tr><td>View structure</td><td>Click on <img src="https://2224254070-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDUF1p2rT0hfE3QBlbbvE%2Fuploads%2FEWeUNELuj3rpAldvVnhY%2Fbd.png?alt=media&#x26;token=528df383-2aa7-4bf1-9aea-10530a1632e1" alt=""> to open a window that allows you to navigate in the structure of the database. <br>You can see the schemas, the tables and views, and information about each field of a table or view.</td></tr><tr><td>Max. rows</td><td>When executing a SELECT SQL query, you can enter a value to limit the number of returned rows.</td></tr><tr><td>Auto commit</td><td>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.</td></tr><tr><td>Test for speed only</td><td>When executing an SQL query, select this option to repeat the query a certain number of times and display the execution times.</td></tr><tr><td>SQL Query</td><td>Enter the SQL query to execute. The result will be displayed in a table.</td></tr></tbody></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.