Actions on table

Learn how to rename, duplicate, and delete a table in NocoDB.

Rename table

  1. Click the ... (ellipsis) next to the table name in the left sidebar and select Rename table from the context menu.
    • Alternatively, double-click on the table name in the left sidebar to make it editable.
  2. Enter the new name for the table in the input field that appears. Use the Enter key to confirm the new name or click outside the input field to save changes.

image

image

Change table icon

  1. Click the current table icon next to the table name in the left sidebar.
  2. Choose a new icon from the available options.

image

Duplicate table

  1. Click the ... (ellipsis) next to the table name in the left sidebar and select Duplicate table.
  2. (Optional) In the dialog:
    • Use Include data to copy the table with or without its records.
    • Use Include views to copy it with or without its saved views.
  3. Click Duplicate Table.

A new table will be created based on your selected options.

image

image

Additional notes

  • Duplicate table will be created in the same base as the original table
  • Duplicate table will carry suffix Copy in its name.
  • Duplicate table option is not available for External DB bases

Delete table

This action cannot be undone
  1. Click the ... (ellipsis) next to the table name in the left sidebar and select Delete table.
  2. In the confirmation dialog, click Delete Table to confirm. image

image

Add / edit table description

Table description can be added by clicking on the Add Description button on the table creation modal or by clicking on the Edit Description button from the table context menu. Description for a table will be visible as a tooltip when hovering over the info icon next to the table name in the left sidebar.

image

Table permissions

Table permissions are available in NocoDB cloud- Team plan onwards and Self hosted Enterprise plans

Table permissions in NocoDB let you control who can create or delete records in each table. Find more details here

Find table ID

Each table in NocoDB has a unique ID (prefixed with m, short for model) that identifies it within a base.

You can find the table ID in the URL when viewing a table.

Example:

https://app.nocodb.com/#/wqd7e84kkpg8169/pqh6trao813gar7/mxo5v3uj1l1xjpz

In this example, the table ID is: mxo5v3uj1l1xjpz

You can also copy the table ID by clicking the ... (ellipsis) next to the table name and selecting Copy Table ID.

image

Usage: Table IDs are commonly used in API calls, scripting, and integrations where you need to reference a specific table.