In the Toolbar, click the Open SQL Editor icon to edit and execute SQL queries and scripts.In the menu-bar, select Window | Open Perspective | DBeaver.To run SQL queries or scripts using DBeaver:
This procedure will explain how to run SQL queries or scripts in your database using DBeaver. Once you have established your connection, you can now begin to work with the data in your database using DBeaver. Click Yes, when prompted to approve the action.
It is much more convenient when the sample URL is specified - in this case the connection wizard will require only valuable connection properties (host name, database name, etc).įor a full breakdown of the available driver editing options, in the Menu bar, go to Help | Help Contents | DBeaver Help | Manage Connections | Driver editor dialog. Sample URL (Optional)- If this value is left blank, you will need to specify the full database URL.You may find the class name in the driver's documentation or click on the "Find Class" button in the "Driver Libraries" tab and choose the class name from the list. It is a name of Java class which implements the driver. Category (Optional) - Some databases have many different drivers, it is convenient to group these drivers.May be used by DBeaver to name scripts, show tips, etc.
Click Yes to download and install the driver files for the selected database.If the driver for the connection type you selected has not been installed, you will be prompted to install it.