Help Center > > User Guide> Microsoft SQL Server Database Management (Standard Edition)> Table Management> Creating a Table

Creating a Table

Updated at: Mar 20, 2020 GMT+08:00

Prerequisites

You have logged in to the DAS console.

Operation Description

A data table consists of basic information, fields, indexes, foreign keys, and CHECK constraints. Indexes, foreign keys, and CHECK constraints 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 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 based on the service requirements.

    • If you do not need to add indexes, foreign keys, or CHECK constraints, click Create at the bottom of the page.
    • If you need to add indexes, foreign keys, or CHECK constraints, click Next at the bottom of the page. After the setting is complete, click Create.

  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