See also, transaction modes and isolation. Manual: the changes submitted to the database server are accumulated in a transaction that can either be committed or rolled back explicitly by means of the Commit ( ) or Rollback ( ) buttons on the toolbar.įor more information about database transaction modes and isolation, refer to Submit changes to a database.Ĭommit the current transaction. Select the isolation level for database transactions and the way the transactions are committed.Īuto: the current transaction is committed automatically when you submit your local changes to the database server. Open the Database | Query Execution section of the Settings dialog to view or edit the query execution settings.įor more information on these settings, refer to Query Execution. Open a dialog that shows all the statements that you have run for the corresponding data source. If nothing is selected, the current statement is executed. By default, IDE uses one of the following as a starting point to resolve the database objects to: selector, or the default database (if none of the above is set).įor more information about resolve modes, refer to Resolve modes.Įxecute selected SQL statement or statements. In order to run SQL scripts, treat the usages of the database objects as links, and provide you with correct code completion, DataGrip must resolve the database objects in your code to a certain context. Read more about the editor in Editor basics. The code editor is where you compose your SQL statements using the resolve modes and coding assistance features, and execute them against the associated data source.įind the code editor toolbar controls in Code editor controls. Read more about managing sessions in Managing connection sessions. You can change the console session to actor or create a new session and attach the console to it. In the following example, the PostgreSQL console is associated with the guest.public schema of a data source and connected to it via the console connection session. You can create new connection sessions and attach your console to existing ones in the console toolbar. Database connection sessionįor each console, a data source connection session is created automatically. When you open an SQL file from your hard drive, you need to specify the connection session first. In query console you can compose and execute your SQL statements.įor example, if you open a query console for PostgreSQL, a connection session to the PostgreSQL data source is automatically created. Query consoles are SQL files that are associated with a data source and connected to it via a connection session.
0 Comments
Leave a Reply. |