Table Basics
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.

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

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
.

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.

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

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.

To truncate a table,
- Right click on table name on the left sidebar and choose Truncate.
- Press
⌘ + S
to commit changes to the server.
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.
To change encoding, navigate to menu
Connection
> View Using Encoding...
Then select the encoding that works for your table of data.Last modified 4yr ago