Help Center/ GaussDB(DWS)/ Tool Guide/ Data Studio - Integrated Database Development Tool/ GaussDB(DWS) Tables/ Creating Partition Table/ Working with Partitions
Updated on 2023-04-03 GMT+08:00
View PDF

Working with Partitions

After creating a table, you can add/modify partitions. You can also perform the following operations on an existing partition:

Renaming a Partition

Dropping a Partition

Renaming a Partition

Follow the steps below to rename a partition:

  1. Right-click the selected partition and select Rename Partition.

    Rename Partition Table dialog box is displayed prompting you to provide the new name for the partition.

  2. Enter new name and click OK.

    Data Studio displays the status of the operation in the status bar.

Dropping a Partition

Follow the steps below to drop a partition:

  1. Right-click the selected index and select Drop Partition.

    Drop Partition Table dialog box is displayed.

  2. Click OK.

    The partition is dropped from the table. Data Studio displays the status of the operation in the status bar.

Parent topic: Creating Partition Table