16.20 - About Reserved Words - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K

Reserved words are used as keywords by Teradata Database 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 Teradata Database adds new reserved words. For every release, the Teradata Vantage™ NewSQL 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.