Help Center/ Data Admin Service/ User Guide/ Distributed DDM DB Instance Management (Development Tool)/ Database Management/ Table Management/ Creating a Table
Updated on 2023-03-07 GMT+08:00
View PDF

Creating a Table

Scenarios

A data table consists of basic information, fields, indexes, foreign keys, and CHECK constraints, among which indexes, foreign keys, and CHECK constraints are optional. Configure these items as required.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects tab, choose Tables and click Create Table.
  2. On the displayed Basic Information page, specify the table name, storage engine, and character set. Then, click Next.
  3. On the Column page, click Add and set Column Name, Type, Nullable, Primary Key, and Extended Information as needed.

    • If you do not need to add indexes, foreign keys, or CHECK constraints, click Create.
    • If you need to add indexes, foreign keys, or CHECK constraints, click Next until all your desired parameters are specified. After the settings are complete, click Create.

  4. In the SQL Preview dialog box, click Execute to create a table.
Parent topic: Table Management