DB2

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