How to delete OS template via database

[harith roli]

please help, I need a way to delete OS template of cloudstack via database. 
Currently the status of template is UploadAbandoned. I try delete using gui, 
Zones --> click button "x" to delete template  but I got message box indicate 
status failed to delete template. Thank you for your help