All Products
Search

This Product

    Tablestore:CreateTable

    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: