> For the complete documentation index, see [llms.txt](https://docs.n8n.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.datatable/tables.md).

# Table operations

Use table operations to create, delete, list and update data tables. Refer to the [Data Table node](/integrations/builtin/core-nodes/n8n-nodes-base.datatable.md) documentation for more information on the node itself.

### Create a data table <a href="#create-a-data-table" id="create-a-data-table"></a>

Use this operation to create a new data table.

Enter these parameters:

* **Resource:** Select **Table**.
* **Operation:** Select **Create**.
* **Name:** Enter a name for the data table, or define using an expression.
* **Columns:** Click **Add Column** to define parameters for the columns of the data table. You can add multiple columns. For each one:
  * **Name:** Set a name for the column, or define using an expression.
  * **Type:** Select the data type for the column: **Boolean**, **Date**, **Number**, or **String**.:

#### Create a data table options <a href="#create-a-data-table-options" id="create-a-data-table-options"></a>

Use these options to further refine the action's behavior:

* **Reuse Existing Tables:** Enable to return an existing table if one exists with the same name, without throwing an error.

### Delete a data table <a href="#delete-a-data-table" id="delete-a-data-table"></a>

Use this operation to permanently delete an existing data table. This action can't be undone.

Enter these parameters:

* **Resource:** Select **Table**.
* **Operation:** Select **Delete**.
* **Data table:** Select how to identify the data table to delete:
  * **From list:** Select the table from a drop-down list of all your data tables.
  * **By Name:** Enter the name of your data table.
  * **By ID:** Enter the ID of your data table

### List data tables <a href="#list-data-tables" id="list-data-tables"></a>

Use this operation to list existing data tables. You can return all tables, all tables up to a defined limit, or filter for tables to return.

Enter these parameters:

* **Resource:** Select **Table**.
* **Operation:** Select **List**.
* **Return All:** Enable to return all matching tables. Or, disable and enter a **Limit** for the number of tables to return, for example `50`.

#### List data tables options <a href="#list-data-tables-options" id="list-data-tables-options"></a>

Use these options to further refine the action's behavior:

* **Filter by Name:** Enter a value or expression to return data tables whose names contain the specified text. Matching is case-insensitive.
* **Sort Field:** Select a field to sort results on.
* **Sort Direction:** Select whether to sort results in **Ascending** or **Descending** direction.

### Update a data table <a href="#update-a-data-table" id="update-a-data-table"></a>

Use this operation to update the name of an existing data tables.

Enter these parameters:

* **Resource:** Select **Table**.
* **Operation:** Select **Update**.
* **Data table:** Select how to identify the data table to update:
  * **From list:** Select the table from a drop-down list of all your data tables.
  * **By Name:** Enter the name of your data table.
  * **By ID:** Enter the ID of your data table
* **New name:** Enter a value or expression to set a new name for the data table.