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 bottomOr 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 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 neededAfter 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