Help Center > > User Guide> DDM DB Instance Management (Standard Edition)> Table Management> Creating a Table

Creating a Table

Updated at: Sep 29, 2020 GMT+08:00

Prerequisites

You have logged in to a DDM DB instance on the DAS console.

Operation Description

A data table consists of basic information, columns, and indexes. As the supplement to table information, indexes are optional and can be configured based on service requirements.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects page, select Tables and click Create Table.
  2. On the displayed page, specify required parameters and set advanced options as required. The table name is mandatory. Click Next.
  3. Set the column name, type, length, nullable, primary key, and extended information based on service requirements.

    • If you do not need to add indexes, click Create directly. In the displayed SQL Preview dialog box, click Execute.

    DDM supports global tables, unsharded tables, and sharded tables. On the basic information page, if you select Yes for Global Table, the table created is a global table. If you select No for Global Table, you need to run SQL statements in the SQL window to create sharded tables.

    • If you need to add indexes, click Next and set the index information. After the setting is complete, click Create at the bottom of the page.

  4. In the SQL Preview dialog box, click Execute to create a table.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel