how about trying below thing ? CREATE PROCEDURE up_test_delete (test_id in varchar) AS BEGIN DELETE FROM tests WHERE tests.test_id= 'up_test_delete.test_id'; DELETE FROM otherTable WHERE otherTable.file_name like '%up_test_delete.test_id%'; END; /