:Create partitions

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.

   

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.