Delete a partition in SQL by using a `DELETE` statement where the partition filter matches the specific partitions you want to remove, ensuring only the targeted data within the partition is deleted.