Added drop statements

Drop statements for each type and procedure.