All Products
Search
Document Center

Tablestore:CreateTable

Last Updated:Dec 08, 2023

Creates a data table based on the specified schema.

Usage notes

  • After you create a data table, you cannot immediately perform read and write operations on the data table. In most cases, you can perform read and write operations on a data table one minute after the data table is created.

  • You can create up to 64 tables in a single instance. If you want to create more tables in a single instance, submit a ticket.

Request syntax

message CreateTableRequest {
    required TableMeta table_meta = 1;
    required ReservedThroughput reserved_throughput = 2; 
    optional TableOptions table_options = 3;
    optional StreamSpecification stream_spec = 5;
}

Parameter

Type

Required

Description

table_meta

TableMeta

Yes

The schema of the data table. Configure the following parameters:

Important

After you create a data table, you cannot modify the schema of the data table.

  • table_name: the name of the data table. The table name must be unique within the instance.

  • primary_key: the information about the primary key. A primary key can contain one to four primary key columns. The name of each primary key column must comply with the naming conventions, and the data types of the primary key columns must be STRING, INTEGER, or BINARY. For more information about the naming conventions and data types, see Naming conventions and data types.

  • defined_Columns: the information about the predefined columns. If you want to use a secondary index for a data table, you must add predefined columns to the data table when you create the data table. Predefined columns are non-primary key columns that are predefined with specific data types. After you add a predefined column to a data table, you can use the predefined column as an attribute column or index key column of an index table. You can also add predefined columns to a data table after the data table is created. For more information, see How do I use predefined columns?

reserved_throughput

ReservedThroughput

Yes

The reserved read or write throughput of the data table. The reserved read or write throughput of a data table cannot exceed 100,000. Unit: capacity unit (CU).

You can call the UpdateTable operation to change the reserved read or write throughput of a data table.

table_options

TableOptions

No

The table parameters, including time_to_live and max_versions.

stream_spec

StreamSpecification

No

Specifies whether to enable Stream-related attributes.

Response syntax

message CreateTableResponse {
}

Use Tablestore SDKs

You can use the following Tablestore SDKs to create a data table based on the specified schema: