Create a Macro | Teradata Studio - Creating a Macro - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Macros are SQL statements that the server stores and executes. Macros provide an easy way to execute frequently used SQL operations.
  1. In the Navigator, expand Databases, right-click a database or user, and select Show Macros.
  2. In the Object List Viewer toolbar, click "" .
  3. Enter values for the new macro.
  4. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new macro.
  5. Click Commit then OK.