16.10 - Keywords - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
June 2017
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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).

In this book, keywords appear entirely in uppercase letters, though SQL does not discriminate between uppercase and lowercase letters in a keyword.

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 Appendix B: “Restricted Words.”