All Products
Search
Document Center

Create partitions

Last Updated: Jun 08, 2019

This section describes how to create partitions in DMS.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Procedure

  1. Select a target database and click Log On to Database.

  2. In the left-side directory, click Create Table. Click the Basic tab, enter the basic table information, and set the table fields and partitions.

    Set the partitions

  3. On the Edit page, click Save to save the table structure that you created. A window appears prompting you to confirm the SQL statement that is used to create the table.

  4. Confirm and Click OK. DMS creates the partitioned table. The SQL statement creates the table based on the partition fields and the partitioning logic that you set.

  5. Check the table structure to verify that the partition table is successfully created.

    Note

    The Partitioned table is successfully created if you can view the partitions.