Column Definition

Column definition options

Grammar Syntax

<column definition> ::=
  <column name>  [ <data type or domain name>  ]
      [ <default clause>  | <identity column specification>  | <generation clause> 
      | <system time period start column specification> 
      | <system time period end column specification>  ]
      [ <column constraint definition> ... ]
      [ <collate clause>  ]

Click here to go to the ANSI SQL Standard specification for this syntax.

Navigate to the following pages to get more details about the translation spec for a specific column definition syntax.

1. Character Set

2. Collate Clause

3. Column Constraint Definition

4. Identity Column Specification