Column Attributes

A column definition sets the attributes of a column.

Description

A column definition sets the attributes of a column.

Grammar Syntax

column_attributes are:
  [ DEFAULT default_expr ]
  [ IDENTITY ( seed, step ) ]
  [ GENERATED BY DEFAULT AS IDENTITY ( seed, step ) ]
  [ ENCODE encoding ]
  [ DISTKEY ]
  [ SORTKEY ]
  [ COLLATE CASE_SENSITIVE | COLLATE CASE_INSENSITIVE  ]

Navigate to the following pages to get more details about the translation spec for the subsections of the content-source section.

  1. DEFAULT default_expr

  2. IDENTITY (seed, step)

  3. GENERATED BY DEFAULT AS IDENTITY ( seed, step)

  4. ENCODE enconding

  5. DISTKEY

  6. SORTKEY

  7. COLLATE

PreviousCREATE TABLENextDEFAULT

Last updated