About Notation Conventions - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
psg1480972718197.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

This appendix describes the notation conventions used in this book.

Convention Description
Syntax Diagrams

Describes SQL syntax form, including options.

Square braces in the text

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.