How to list down all defined macros in teradata?

@denis 

To list down all defined macros in Teradata, you can use the following SQL query:

1
2
3
4
5
6
7

SELECT 
    databasename, 
    definitionname,
    requesttext,
    updatetime
FROM 
    dbc.macros;

This query selects the database name, macro name, macro definition, and last update time of all macros from the DBC database in Teradata.

You can run this query in any Teradata SQL client or through a Teradata command line interface.