Reserved Words | Teradata Vantage - 17.00 - 17.05 - About Reserved Words - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Node Software Migration Guide

Advanced SQL Engine
Teradata Database
Release Number
Release Date
June 2020
Content Type
Publication ID
English (United States)

Reserved words are used as keywords by Advanced SQL Engine or ANSI/ISO SQL. They cannot be used as identifiers to name database objects, such as databases, tables, columns, or stored procedures. They also must not be used as macro or stored procedure parameters or local variables, host variables, or correlation names.

Each new release of Advanced SQL Engine adds new reserved words. For every release, the Teradata Vantage™ - Advanced SQL Engine Release Summary, B035-1098 includes a list of the new reserved words. Teradata provides a view and table function that you can use to generate a complete list of reserved, nonreserved, and future reserved words. For more information, see Teradata Vantage™ - SQL Fundamentals, B035-1141.

The pre-migration script runs the check_reserved_words.bteq and check_reserved_words_tpt.bteq scripts to check for reserved words used by the database and by the Teradata Parallel Transporter (TPT) load utility. If you use TPT, you should check the results in reservedwords_tpt.rpt.