Table Basics

Show table overview

To see the overview of the current table list, click on the header "Tables" on the left sidebar, or right click on any table any choose Overview items.

View table data

To view a table and its content, click on table name on the left sidebar, or use Open Anything (⌘ + P)

From table structure view, to go back to the table data view:

  • Click on the Data button at the bottom

  • Or use shortcut keys ⌘ + ^ + [

TablePlus support paging when showing table data. By default, it shows 300 rows per page.

You can change the limit number of rows per page:

  • Click on the config/setting button at the bottom of the table

  • Edit and enter the new value for the Limit field

  • Enter the offset value if you need

  • Click Go

View table structure

To view a table structure:

  • When viewing table data:

    • Click on the Structure tab at the bottom

    • Or use shortcut key ⌘ + ^ + ].

  • Or you can right click on the table name on the left sidebar and choose Open structure.

Show table creation

Currently, there are two ways to show the CREATE TABLE commands:

  • Using the Definition button:

    • When viewing table data, click on the Structure tab at the bottom, or use shortcut key ⌘ + ^ + ]. Or you can right click on the table name on the left sidebar and choose Open structure.

    • Click on the Definition button at the top right to show table creation.

  • Or using the Dump Table Plugin:

    • Navigate to Plugin > Manage plugins, or use the shortcut key ⌘ + L

    • Install Dump Table plugin.

    • Right click on the table, choose Copy Script As > CREATION

Using the Dump Table Plugin, you also have options to Copy Script As: DROP, TRUNCATE, and Laravel Migration.

Create table

To create a new table from the GUI:

  • Click on the + button at the bottom of the left sidebar, or right click on the left sidebar and choose New > Table.

  • Enter the table name

  • Add new column by clicking on the + Column at the bottom, or double click on the blank row.

  • Specify the column's attributes: name, datatype, nullability, default.

  • Specify the table's Primary Key in the Primary field, if needed

  • After you finish, press ⌘ + S to commit changes to the server.

Rename Table

To rename a table:

  • Open the table structure view

  • Enter the new name in the name text box at the top of the window.

  • Press ⌘ + S to commit changes to the server.

Truncate Table

To truncate a table,

  • Right click on table name on the left sidebar and choose Truncate.

  • Press ⌘ + S to commit changes to the server.

Delete Table

To delete a table,

  • right click on table name on the left sidebar and choose Delete, or select the table and press Delete key.

  • Press ⌘ + S to commit changes to the server.

Change Encoding

To change encoding, navigate to menu Connection > View Using Encoding... Then select the encoding that works for your table of data.

Last updated