The following table lists the basic SQL statements that you can use with macros.
| Use this statement… | To… |
|---|---|
| CREATE MACRO | incorporate a frequently used SQL statement or series of statements into a macro. |
| EXECUTE | run a macro. A macro can also contain an EXECUTE statement that executes another macro.
|
| DROP MACRO | delete a macro. |