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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
Configuration
Installation
featnum
B035-5942-170K

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.