Actions on base

Understand the structure, actions, and developer tools available in a base.

Base context menu

The base context menu offers a selection of swift actions that can be executed on a base. To access this menu, click on the ellipsis symbol (...) located adjacent to the base name within the left sidebar. base context menu

Rename base

  1. Open Base context menu.
  2. From dropdown, select Rename option.
  3. Edit the name and press Enter to save.

base context menu

base rename

Star base

You can star a base by following simple steps below:

  1. Open Base context menu.
  2. From dropdown, select Add to starred option.

Subsequently, the base will be placed into the "Starred" section, conveniently positioned within the left sidebar.

base context menu

base starred

Remove a base from starred list

You can star a base by following simple steps below:

  1. Open Base context menu.
  2. From dropdown, select Remove from starred option.

image

Duplicate base

  1. Open Base context menu.
  2. From dropdown, select Duplicate base option.
  3. Duplicate base optional configurations,
    • Include records - disable to duplicate the base schema only, without any data.
    • Include comments - disable to duplicate the base without any comments.
    • Include scripts - disable to duplicate the base without any scripts.
  4. You can select a workspace from the dropdown to duplicate the base into. By default, the base will be duplicated within its current workspace. Only workspaces where you have access will appear in the dropdown.
  5. Click the Duplicate Base button to proceed with the duplication.

A new base will be created, mirroring the original base's schema and data and/or comments based on the configurations specified in step 3.

base context menu

image

You will be designated as the base owner upon the duplication of the base. Existing base members will not be transferred to the duplicated base.

Delete base

If you determine that a base is no longer necessary, you have the option to permanently remove it from your workspace. Deleting a base will delete all the tables and data associated with it.

Only base owner can delete a workspace. This action cannot be undone

To delete a base:

  1. Open Base context menu.
  2. From dropdown, select Delete base option.
  3. Select Delete base button on the confirmation dialog box.

base context menu

base delete

Find base ID

Each base in NocoDB has a unique ID (prefixed with p, short for project) that identifies it within a workspace. You can find the base ID in the URL when viewing a base.

Example:

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

In this example, the base ID is: pqh6trao813gar7

Developer features

Base settings

Some general configurations are available for you to modify within the base settings.

  1. Show M2M tables: Toggle this option to display/hide M2M tables within the left sidebar. Many-to-many relation is supported via a junction table & is hidden by default.
  2. Show NULL in cells: Toggle this option to display/hide NULL values within the cells of the table. This helps differentiate against cells holding EMPTY string.
  3. Show NULL & Empty in Filters: Enable 'additional' filters to differentiate fields containing NULL & Empty Strings. Default support for Blank treats both NULL & Empty strings alike.

To configure base settings, you can follow these steps:

  1. Open Base context menu.
  2. From dropdown, select Settings option.

base context menu

base settings

REST APIs

NocoDB provides a Swagger UI for each base. To access the Swagger UI, follow these steps:

  1. Open Base context menu.
  2. From dropdown, select REST APIs option.

base context menu

swagger

Relations

NocoDB provides a visual representation of the relations between tables within a base. To access the relations diagram, follow these steps:

  1. Open Base context menu.
  2. From dropdown, select Relations option.

base context menu

base relations