How to export Public Synonyms using Export DDL functionality.
Open Export DLL dialog by going to the Database menu | Export | Export DDL.
While in the dialog, next to the Add button, there's a a tiny button with an upside down triangle. This button has two options; the 'Simple' and 'Advanced'. Select the Advanced option to open the 'Object Search' dialog. Specify the Schema for each Synonym that you want to export and under checked 'Search object names', make sure just 'SYNONYM' is checked. Uncheck all the other object types. Then click 'Search for database objects' at the top left hand corner. When a list of Synonyms is displayed in the Results tab, you can further filter the results by clicking on the blue upside down triangle next to the Object Name. Click ok to add Synonyms to Objects & Output tab.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center