15.00 - Appendix A Notation Conventions - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

This appendix describes the notation conventions used in this book.

Throughout this book, three conventions are used to describe the SQL syntax and code:

  • Syntax diagrams, used to describe SQL syntax form, including options. See “Syntax Diagram Conventions”.
  • Square braces in the text, used to represent options. The indicated parentheses are required when you specify options.
  • For example:

  • DECIMAL [(n[,m])] means the decimal data type can be defined optionally:
  • without specifying the precision value n or scale value m
  • specifying precision (n) only
  • specifying both values (n,m)
  • you cannot specify scale without first defining precision
  • CHARACTER [(n)] means that use of (n) is optional.
  • The values for n and m are integers in all cases.

  • Japanese character code shorthand notation, used to represent unprintable Japanese characters. See “Character Shorthand Notation Used In This Book” on page 1018.