# Column

## **Insert column**

To insert a new column to the current table:

* Open the table structure view (**`⌘ + ^ + ]`**)
* Click on the **`+ Column`** button at the bottom, or double click on the blank row under column section, or use shortcut key **`⌘ + I`** when selecting a column.
* Specify column's attributes: name, datatype, nullability, default.
* Press **`⌘ + S`** to commit changes to the server.

![](/files/-Lrsh5jeierdV236cs6R)

## **Edit column**

This can only applies to databases that support altering column.

To edit a column

* Open the table structure view (**`⌘ + ^ + ]`**)
* Double click on column's attribute and edit inline
* Press **`⌘ + S`** to commit changes to the server.

Or you can turn on the right toggle to edit by pressing the Space key. This will be helpful when you do bulk edits.

## **Delete column**

* Open the table structure view (**`⌘ + ^ + ]`**).
* Select the column and press Delete key, or right click and choose Delete.
* Press **`⌘ + S`** to commit changes to the server.


---

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