Skip to content

Drop all synonym from owner

by Mohamed Azar on July 4, 2019

Drop all synonym from owner

set head off
set newpage none
set pagesize 9999

spool drop_synonym.sql

select ‘drop synonym ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from dba_objects where OWNER =’OWNER’ and OBJECT_TYPE =’SYNONYM’;

spool off

From: Administration
←
→
No comments yet

Leave a comment