> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/working-with-table/table.md).

# 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**.

![](/files/-Lrp08UTqlnV50kiyOgX)

## **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**

![](/files/-Lrp2l5Ps2tEixbdrW16)

## **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`**.

![](/files/-Lrp2JGu8IVDI_MgvKWw)

## **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`**

{% hint style="info" %}
Using the Dump Table Plugin, you also have options to **`Copy Script As:`** **`DROP`**, **`TRUNCATE`**, and **`Laravel Migration.`**
{% endhint %}

![](/files/-Lrp34mIqNfXMaKa0LXv)

## **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.

![](/files/-Lrp4Qzq1_MNKTsJp2GQ)

## **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.

![](/files/-LrpA_KWpISMALbf5D5G)

## **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.