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.

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

Rename database

Only applies if the Database System supports renaming the database
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

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
Last modified 2yr ago