16.10 - Overview - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
klx1480972732157.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
toy1472253184295

Throughout this book, these conventions describe the SQL syntax and code:

  • Syntax diagrams, used to describe SQL syntax form, including options.
  • 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 and 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.

Related Topics

For more information about: