Example - Emptying a Partition v13
The example that follows removes the data from a partition of the sales
table. Use the following command to create the sales
table:
Populate the sales
table with the command:
Querying the sales
table shows that the partitions are populated with data.
To delete the contents of the americas
partition, invoke the following command:
Now, querying the sales
table shows that the content of the americas
partition has been removed.
While the rows have been removed, the structure of the americas
partition is still intact.