Help Center/ Data Admin Service/ User Guide (ME-Abu Dhabi Region)/ User Guide/ Microsoft SQL Server DB Instance Management (Development Tool)/ Database Management/ Table Management/ Creating a Table
Updated on 2023-03-28 GMT+08:00
View PDF
Share

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 page, select Tables and click Create Table.
  2. On the displayed Basic Information page, specify the table name, schema, table lock escalation, and comment. 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