You are here: Reference Information > SQL Reference Information > SQL Statements > UNMAP PARTITION

UNMAP PARTITION

UNMAP PARTITION — remove the association between a table partition and a storage group

Syntax

UNMAP PARTITION partition_name [ IF EXISTS ]

Description

The UNMAP PARTITION command removes an association between a table partition name and a storage group. This has no effect on existing partitioned tables, whether its table partition mapping was created using the STORE IN clause or using the MAPcommand. UNMAP will succeed even if there are partitions using partition_name. See Example 2 below. The UNMAP PARTITION command has no effect on the storage group mapping to SMs. For information on how to create an association between a table partition name and a storage group, see MAP PARTITION. For information on creating or removing storage groups, see Managing Storage Groups.

Note: The UNMAP PARTITION command, table partitions and storage groups are preview features. NuoDB encourages you to use preview features in your development projects. However, the use of preview features in production is not supported.

Parameters

Examples