> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/untitled.md).

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

![](/files/-LrorsVOMILvn_d4peAS)

## **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`**

![](/files/-LrotWkTuy_lIL9DHwdh)

## **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`**

![](/files/-LrourmcVbHIf2LzhxG5)

## **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`**

![](/files/-LrovSve4EpTpibD1p01)