# Database

## **Switch database**

To show the list of databases in the current connection and make a switch, click on the Show databases button on the top left panel, or use shortcut key ⌘ + K.

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LropmXSjGmb--W48OXd%2F-LrorsVOMILvn_d4peAS%2Fswitch%20database.gif?alt=media\&token=a402ad76-26d9-49db-b523-caa008800297)

## **New database**

To create a new database in the current connection:

* Click on the Show connections button on the top left panel, or use shortcut key **`⌘ + ⇧ + K`** to show database list.
* Click on the **`+`** button
* Specify name, encoding, and collation for the new database
* Hit **`Create`**

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LropmXSjGmb--W48OXd%2F-LrotWkTuy_lIL9DHwdh%2Fnew-db.gif?alt=media\&token=d640eb1d-a65a-4efe-90bc-1e7381def7c4)

## **Rename database**

{% hint style="info" %}
Only applies if the Database System supports renaming the database
{% endhint %}

To rename a database in the current connection:

* Click on the Show connections button on the top left panel, or use shortcut key **`⌘ + ⇧ + K`** to show database list.
* Right-click on the database name
* Specify a new name
* Hit **`Rename`**

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LropmXSjGmb--W48OXd%2F-LrourmcVbHIf2LzhxG5%2Frename%20db.gif?alt=media\&token=bcd4f84c-b2d3-4cad-8684-76e25f070087)

## **Drop database**

To drop a database in the current connection:

* Click on the Show connections button on the top left panel, or use shortcut key **`⌘ + ⇧ + K`** to show database list.
* Right click on the database and choose **`Drop...`**, or select the database and click **`-`** button.
* Hit **`Drop`**

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LropmXSjGmb--W48OXd%2F-LrovSve4EpTpibD1p01%2Fdrop-db.gif?alt=media\&token=64f659e6-5f10-44bd-9f22-dd5a30c9beb8)