TablePlus Documentation
  • Overview
  • Getting Started
  • GUI Tools
    • The Interface
      • Quick Look
      • Menu
      • Toolbar
      • Left sidebar
      • Right sidebar
      • Console Log
      • Query Editor
      • Multi Tabs / Workspaces / Windows
    • Open Anything
    • Code Review & Safemode
      • Code Preview
      • Commit changes
      • Discard changes
      • Safe mode
    • Connections & Command Line (CLI)
    • Database
    • Working with Table
      • Table Basics
      • Row
      • Column
      • Constraint
      • Index
      • Trigger
    • Filter
    • Database Objects
      • Function
      • Procedure
      • View
    • Import & Export
    • Backup & Restore
    • User Management
    • Metrics board
  • Query Editor
    • Editor Basics
    • Multiple Carets
    • Query Favorite & Keyword Binding
    • Query History
    • Streaming Results & Async Loading
    • Autocomplete
    • Split Panes
    • Split Results into Tabs
    • Working With Query Results
    • Format query (beautify/minify/uglify)
    • Query Parameters
    • Customize Query Editor
  • Preferences
    • General
      • Application
      • Table Data
      • SQL Editor
      • CSV File
      • Connections
    • Fonts & Colors
    • Crash & Security
    • Keymap
  • Utilities
    • Plugin
    • DBngin
    • Shortcut Keys
    • Licensing
    • Troubleshooting
Powered by GitBook
On this page
  • Switch database
  • New database
  • Rename database
  • Drop database

Was this helpful?

  1. GUI Tools

Database

PreviousConnections & Command Line (CLI)NextWorking with Table

Last updated 5 years ago

Was this helpful?

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