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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tableplus.com/gui-tools/working-with-table/table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.