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

Creating a Table

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

Prerequisites

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

Operation Description

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.

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