SAND CDBMS Administration Guide
Massively Parallel Processing (MPP)

Deleting Partitioned Tables

To delete a partitioned table from the head node, simply execute the standard DROP TABLE command with the partitioned table specified.

To delete a partitioned table and its related database objects, including remote tables, add the CASCADE keyword to the end of the DROP TABLE command. This command will remove the following objects:

• the specified partitioned table
• each linked table that was specified in the partitioned table creation statement
• the remote tables (partitions) associated with the link tables
• the default partition of each user that had the partitioned table set as default

Note:
The connection objects used for the link tables are not removed via the CASCADE option.