Create Macro in Teradata

A macro allows us to name a set of one or more statements and execute it as a group.

The syntax of creating Macro is:-

CREATE MACRO MACRO_NAME AS
(
 SQL_STATEMENTS;
) ;

Sample Macro is:-

CREATE MACRO MY_MACRO AS
(
SELECT * FROM PROD.EMPLOYEE;
) ;