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 the Databases, right-click a database or user, and click Show Macros. A list of the macros defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
-
In the Object List Viewer toolbar, click .
A Create Macro property form opens in the Details view.
- In the form, 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.
- Click OK. The property form shows the properties of the new macro.