Delete a table in own schema
BEGIN DECLARE v_userSchema varchar(20); values current schema into v_userSchema; IF EXISTS (SELECT NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T' AND CREATOR = v_userSchema AND NAME = 'T_REFERRAL_DELETE') THEN DROP TABLE T_REFERRAL_DELETE; END IF; END