CREATE PROCEDURE delete_car_model(@del_car_model_name VARCHAR(32)) AS BEGIN DELETE FROM nmrm_car_model WHERE car_model_name = @del_car_model_name; END;