Overview of SQL data types

The following overview indicates the syntax for all SQL data types used in column definitions:

---

datentyp ::=
{

[{[ dimension ] | ( dimension )}] CHAR[ACTER][( length )] |

{ CHAR[ACTER] VARYING | VARCHAR } ( max ) |

[{[ dimension ] | ( dimension ) }] { NATIONAL CHAR[ACTER] | NCHAR }[( cu_length  [CODE_UNITS])] |

{ NATIONAL CHAR[ACTER] VARYING | NCHAR VARYING | NVARCHAR }  ( cu_max [CODE_UNITS] ) |

[{[ dimension ] | ( dimension )}]

{

SMALLINT |

INT[EGER] |

NUMERIC [( precision [, scale ])] |

DEC[IMAL][( precision [, scale ])] |

REAL |

DOUBLE PRECISION |

FLOAT [( precision )] |

DATE |

TIME(3) |

TIMESTAMP(3)

}

}

---

Any square brackets shown here in italics are special characters, and must be specified in the statement.

The data types are described in the order in which they are listed in the overview.