16.20 - Keywords - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Keywords are words that have special meanings in SQL statements.

Statement Keyword

The statement keyword, the first keyword in an SQL statement, is usually a verb. For example, in the INSERT statement, the first keyword is INSERT.

Other Keywords

Other keywords appear throughout a statement as qualifiers (for example, DISTINCT, PERMANENT), or as words that introduce clauses (for example, IN, AS, AND, TO, WHERE).

By convention, keywords appear entirely in uppercase letters. However, SQL keywords are not case sensitive and can be in uppercase or lowercase letters.

For example, SQL interprets the following SELECT statements identically:

Select Salary from Employee where EmpNo = 10005;
SELECT Salary FROM Employee WHERE EmpNo = 10005;
select Salary FRom Employee WherE EmpNo = 10005;

All keywords must be from the ASCII repertoire. Full-width letters are not valid regardless of the character set being used.

Related Topics

For information on restricted keywords, see the "Overview" topic in Restricted Words.