REPLACE MACRO in Teradata

To update a macro by changing the inner SQL statements inside it,

REPLACE MACRO <macro name> [parameters] AS
(
<SQL statements updated>
);


Example:
CREATE MACRO mc_employee AS
(
SELECT * FROM tbl_employee;
);

REPLACE MACRO mc_employee AS
(
SELECT * FROM tbl_employee WHERE emp_no >10;
);