set bail on;
set heading off;
set echo on;
shell if exist r:\temp\tmp4test.fdb del r:\temp\tmp4test.fdb;
create database 'localhost:r:\temp\tmp4test.fdb' user sysdba password 'masterkey';
--create database 'r:\temp\tmp4test.fdb' user sysdba;
set term ^;
create or alter package pg_test as
begin
-- empty! --
end
^
commit
^
execute block as
begin
execute statement ('drop package body pg_test');
execute statement ('drop package pg_test');
end
^
commit
^
select rdb$get_context('USER_SESSION', 'foo') as "Finish. Total objects removed:" from rdb$database