Example: Emptying a partition v16
This example removes the data from a partition of the sales
table.
Create the sales
table:
Populate the sales
table:
Query the sales
table to show that the partitions are populated with data:
Delete the contents of the americas
partition:
Query the sales
table to show that the contents of the americas
partition were removed:
The rows were removed, but the structure of the americas
partition is intact: