CREATE/REPLACE MACRO Syntax | Teradata Vantage - CREATE MACRO and REPLACE MACRO Syntax - Advanced SQL Engine - Teradata Database

{ CREATE MACRO | CM | REPLACE MACRO } [ database_name. ] macro_name
  [ ( macro_parameter [,...] ) ]
  AS ( [ USING using_modifier ]
       [ LOCKING locking modifier ][...]
       SQL_statement ;
      ) [;]

macro_parameter

parameter_name type_declaration [ type_attribute ]...