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