Macros in 4D v11 SQL are stored in a folder named "Macros v2". This folder can be placed at the following locations:

-In the active 4D folder of the machine. This allows the macros to be used by any database on the machine.
-In the same directory as the structure file. This allows the macros to only be used with the structure within its directory.
-In the "Components" folder of the database. Macros can only be used if the component is installed.