---
title: "Tables"
url: https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/tables/
description: "Catalyst Data Store is a highly-scalable, cloud-based relational database that stores the persistent data of your app that includes the data from the application’s backend and the data of the application’s end users."
last_updated: 2026-08-17T12:16:04Z
service: Cloud Scale
type: general
---

# Tables

You can create tables in the Catalyst Data Store to store your application's data. You can create columns for a table that categorize and group similar data together, and then create records.

In Catalyst terminology, the **rows** in the Data Store represent the individual records of the table, and the **columns** represent the fields that are created for a table.

### Create a New Table

To create a new table in the Data Store:

1. Navigate to **Data Store** under _Storage_ in the Catalyst Cloud Scale console.
2. In the _Data Store_ page, click **Create a new Table**.
 
![Data Store- Create a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store.webp)

3. Enter the **Table Name** in the text box and click **Create**.
 
![Data Store- Create a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_create_table.webp)

> **Note:** The table name can only contain alphanumeric characters and underscores. Do not include any whitespace or special characters. The table name should also not start with any numeric characters.

The table is now created and displayed in the _Data Store_ page. All tables that you create will be listed on the left hand side of the page.

![Data Store- Table Created](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_table_created.webp)

Once your table is created, a unique **Table ID** is created for it automatically. You can use it to refer to the table when working with the SDKs and APIs. You can find the Table ID under the table's name when you click on a table from the list.

You can use the search box to search for a particular table by its name.

When you create a new table in the Data Store, a set of default columns for its characteristics are created automatically. You can learn more about these columns in the [next section](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/columns/#default-columns).

### Update a Table Name

To update a table name in the Data Store:

1. In the _Data Store_ page, click the ellipsis icon for the table that needs to be renamed and click **Edit**.
 ![Data Store- Edit a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_table_edit.webp)

2. Enter the new name for the table and click **Update**.
 ![Data Store- Edit a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_table_rename.webp)

### Truncate a Table

The truncate operation deletes all the records in the table, while retaining its schema. The columns of the table and the table's metadata will still be available, after the operation has ended.

You can truncate a table if you want to re-populate a table with a new set of data periodically and clear the old data. You can also perform this operation if you want to avoid creating a new table from scratch, and use an existing table with pre-defined schema instead.

To truncate a table in the Data Store:

1. Click the **ellipsis icon** for the table that needs to be truncated, then click **Truncate**.

![Data Store- Truncate a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_truncate.webp)

2. Enter "**TRUNCATE**" in the pop-up window to confirm the operation, then click **Confirm**.
 
![Data Store- Truncate a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_truncate_confirmation.webp)

The truncate process will be initiated. A Catalyst scheduler will run in the background and execute the operation. You will be able to perform other operations in the Data Store while the truncate operation is still in progress.

After the truncate is complete, you will receive a notification in the console about the status of the operation.

![Data Store- Truncate a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_truncate_notification.webp)

### Delete a Table

To delete a table from the Data Store:

1. Click the ellipsis icon for the table that needs to be deleted, then click **Delete**.
 ![Data Store- Delete a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_delete_table.webp)

2. Click **Yes, Proceed** in the confirmation pop-up.
 ![Data Store- Delete a Table](https://catalyst-docs-development.zohostratus.in/images/help/data-store/catalyst_data_store_delete_table_confirmation.webp)

 The table is now deleted from the Data Store.