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