Skip to content

DbColumn

do- edited this page Jan 8, 2023 · 35 revisions

DbColumn is an object describing a column of a relation (a regular data table or some similar object like SQL view etc.) in a database.

Properties

Name Type Description
name String Name (identifier) of this column
comment String Comment for this column
type String Name of the data type
size int Maximum size of the data (length for VARCHAR, precision for DECIMAL etc.). The exact meaning (units etc.) and the mere existence meaning depends of the type.
scale int For DECIMAL, his synonyms and/or derived types, (NUMERIC etc.) means the length of the fractional part. Must be absent for other types.
default String The DEFAULT clause of the corresponding CREATE/ALTER TABLE statement. Always presented as a String, including numeric types. Explicit DEFAULT NULL is defined by a 4-letter string 'NULL'.

Clone this wiki locally