Delete a file by name from a shared drive

Deletes a file by name from a shared drive. Supply the file name in the WHERE clause and the shared drive ID in WITH. Use Trashed=0 to target only non-trashed files.

DELETE FROM Files
WHERE Name='dump.csv' AND Trashed=0
WITH(DriveId='0AC00HWQH144cUk9PVA', DriveType='drive')