Macros are SQL statements that the server stores and executes. Macros provide an easy way to execute frequently used SQL operations.
- In the Navigator, expand Databases, right-click a database or user, and select Show Macros.
- In the Object List Viewer toolbar, click .
- Enter values for the new macro.
- [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new macro.
- Click Commit then OK.