Bulk delete or deleting an entire collection

Hi,

Is there a way to do a bulk deletion of collection items in Runway, or a way to delete all collection items for a specific collection. I just tried deleting a collection via the CMS and I can still see all the collectio item records in the database.

If not is there a SQL query I can run to clear the database of these?

Many thanks

Lee