Reserved Words | Teradata Vantage - 17.10 - About Reserved Words - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-171K
Language
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.