Help Center > > User Guide> Microsoft SQL Server DB Instance Management (Development Tool)> Database Management> Table Management> Creating a Table

Creating a Table

Updated at: Jun 09, 2021 GMT+08:00

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.

    Figure 1 Create Table

  2. On the displayed Basic Information page, specify the table name, schema, table lock escalation, and comment. Click Next.

    Figure 2 Basic Information

  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.

    Figure 3 SQL Preview

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