--Developing Oracle Applications with Developer/2000
--@C:\DEV2000\SQL\DROPSYN.SQL

spool C:\DEV2000\SQL\DROPSYN.TXT

Prompt Developing Oracle Applications with Developer/2000
connect system/manager
Prompt Dropping Public Synonyms as...

select substr (user,1,20) User_Id,
sysdate Sys_Date,
substr (to_char(sysdate, 'HH:MIAM'),1,10) Sys_Time from dual;

drop public synonym contact;
drop public synonym customer;
drop public synonym dept;
drop public synonym emp;
drop public synonym emp_audit;
drop public synonym rpt_audit;
drop public synonym state;
drop public synonym contacts;
drop public synonym customers;
drop public synonym departments;
drop public synonym employee_audits;
drop public synonym employees;
drop public synonym report_audits;
drop public synonym states;

Prompt Done Dropping Public Synonyms.

spool off;
