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

Creating a Table

Updated at: May 14, 2020 GMT+08:00

Prerequisites

You have logged in to the DAS console and entered the Standard Edition page.

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 tab, choose Tables on the left and click Create Table in the right pane.
  2. On the displayed tab, specify the required parameters and set the advanced options as required. The table name is mandatory. Click Next.
  3. Set the following fields based on the service requirements: column name, type, length, nullable, primary key, and extended information.

    • If you do not need to add indexes, click Create at the bottom of the page. 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 the 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