Help Center > > User Guide> Microsoft SQL Server DB Instance Management (Standard Edition)> Overview> Table Creation

Table Creation

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

Prerequisites

You have logged in to a Microsoft SQL Server DB instance on the DAS console.

Scenarios

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

Procedure

  1. In the database list of the Home page, locate the target database and click Create Table in the Operation column.
  2. On the displayed page, specify the details under Basic Information (Table Name and Schema are mandatory). 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, directly click Create. In the displayed SQL Preview dialog box, click Execute.
    • 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.

    When you create a foreign key, the type of columns in the referenced table must be the same as that of included columns, and must be the primary key or have a unique index.

  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