--- title: "Create and Manage Tables" url: https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/create-manage-tables/ description: "Catalyst NoSQL is a fully-managed, powerful database that provides you with a non-relational, non-SQL means of data storage. Create, manage, and query data in NoSQL tables with ease, and perform CRUD operations in Java, Node.js, and Python." last_updated: 2026-08-28T06:26:16Z service: Cloud Scale type: general --- # Create and Manage Tables in NoSQL Let's now discuss working with NoSQL tables from the Catalyst console. > **Note:** The configurations made in this section, such as adding and managing tables, can only be done from the remote console, and not through the SDKs or API. You can perform data operations from the server-side SDKs and API. You can access NoSQL in your Catalyst project from the [CloudScale service](https://docs.catalyst.zoho.com/en/cloud-scale/) in your console. ### Create a Table To create a table in Catalyst NoSQL in your project: 1. Navigate to the **CloudScale** service in the console, then click **NoSQL**. ![catalyst_nosql](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_access.webp) 2. Click **Create Table**. 3. Enter a name for the table. You must configure the [*Partition Key*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) by providing a key name and selecting the data type of the key. > **Note:** You can only configure the partition key with the data types String, Numeric, or Binary. To learn about the supported data types and their notations, refer to [this section](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/introduction/#supported-data-types). ![nosql_create_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_table_1.webp) > **Note:** You will not be able to modify or delete the partition key configured for a table, or delete the partition key attribute from any data item, after you configure it. Because this is the primary key, all items must include this value. 4. You can optionally configure a [*Sort Key*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) for the table to include a *Composite Primary Key* by selecting **Yes** for "Include Sort Key?". However, if you only prefer having the partition key (*Simple Primary Key*), then select **No**. If you include a sort key, enter the key name and select the data type of the key. > **Note:** * You will not be able to modify or delete the *Sort Key* in a table, after you configure it. * You can only configure the sort key with the data types String, Numeric, or Binary. To learn about the supported data types and their notations, refer to [this section](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/introduction/#supported-data-types). 5. If you require [*Additional Sort Keys*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) to be included in your table, you can add them by providing the key name and selecting the data type. You can add multiple keys by clicking (+). ![nosql_create_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_table_2.webp) > **Note:** * You will not be able to modify or delete the *Additional Sort Keys* in a table, after you configure it. * Catalyst allows you to configure a **maximum of 5** *Additional Sort Keys* in a table. * You can only configure the additional sort keys with the data types String, Numeric, or Binary. To learn about the supported data types and their notations, refer to [this section](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/introduction/#supported-data-types). 6. Configure an attribute to store the [*TTL timestamp*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#time-to-live-ttl) for the table. You can add values for this attribute for each item in the table to indicate their expiration date. ![nosql_create_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_table_3.webp) > **Note:** You can disable the TTL attribute in a table after you configure it. However, you will not be able to change the attribute's name, or enable/configure it again once disabled. 7. After you configure the table, click **Create**. The NoSQL table will be created and listed under *Tables* in your project. Catalyst will automatically create a **unique Table ID** for your table that you can use to refer it while performing SDK and API actions. There are three sections in the table: *Overview*, *Indexes*, and *Data*. ### The Overview Section The *Overview* section provides a glimpse of the table's configuration and details. It displays all essential information, such as the unique Table ID, details of the person who created it, the TTL attribute, etc. ![nosql_overview](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_table_created.webp) The *Storage Size* indicates the size of the table. An empty table will contain 0 bytes, as well as 0 data items. Catalyst operates a built-in scheduler once every 24 hours that calculates and updates the *Storage Size* and *No. of Items* of each table. You can also view the partition key, sort key, and additional sort keys configured for the table. The *No. of Indexes* indicates the number of indexes created from the table. Click **View** here to navigate to the Indexes section. ### Edit a Table You can edit a table in NoSQL and modify the table name, or disable the [TTL attribute](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#time-to-live-ttl) configured for a table. However, you will not be able to modify the partition key, sort key, and additional sort keys that you set up, or the name of the TTL attribute. To edit a NoSQL table: 1. Click the ellipsis icon from the *Overview* section of the table, then click **Edit**. ![nosql_edit_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_edit_table_1.webp) 2. Modify the required details of the table, then click **Update**. ![nosql_edit_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_edit_table_2.webp) > **Note:** If you disable the TTL attribute, you will not be able to enable or configure it again for the table. Disabling the TTL attribute will stop Catalyst from automatically deleting expired data items from the table. ### Delete a Table You can permanently delete a table and all the data it contains in NoSQL in the following manner: 1. Click the ellipsis icon from the *Overview* section of the table, then click **Delete**. ![nosql_delete_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_delete_table_1.webp) 2. Click **Delete** in the confirmation pop-up. ![nosql_delete_table](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_delete_table_2.webp)