Column
Property keys mapped to the columns of the OpenEdge SQL `SYSCOLUMNS` system catalog table.
SYSCOLUMNS contains one row for every column of every table and view in
the database, including system tables.
Tags
Table of Contents
Constants
- CASE_SENSITIVE : string = 'caseSensitive'
- Whether the column comparison is case sensitive (`case-sensitive`).
- CHAR_SET : string = 'charSet'
- Character set used by the column (`charset`).
- COLLATION : string = 'collation'
- Collation used by the column (`collation`).
- COLUMN_ID : string = 'columnId'
- Ordinal position of the column within the table (`colid`).
- COLUMN_TYPE : string = 'columnType'
- Data type of the column (`coltype`), e.g. `INTEGER`, `VARCHAR`.
- DECIMAL : string = 'decimal'
- Number of decimal digits after the decimal point (`decimal`).
- DEFAULT_VALUE : string = 'defaultValue'
- Default value of the column (`dflt_value`).
- FORMAT : string = 'format'
- Display format string used by the OpenEdge 4GL (`format`).
- LABEL : string = 'label'
- Display label used by the OpenEdge 4GL (`label`).
- MANDATORY : string = 'mandatory'
- Whether the column is mandatory in the 4GL schema (`mandatory`).
- NULL_FLAG : string = 'nullFlag'
- Whether the column accepts the SQL NULL value (`nulls`/`nullFlag`).
- PRECISION : string = 'precision'
- Numeric precision of the column (`precision`).
- RADIX : string = 'radix'
- Numeric radix used by `precision` (`radix`).
- SCALE : string = 'scale'
- Numeric scale of the column (`scale`).
- TABLE : string = 'table'
- Owning table of the column.
- WIDTH : string = 'width'
- Storage width of the column in bytes (`width`).
Constants
CASE_SENSITIVE
Whether the column comparison is case sensitive (`case-sensitive`).
public
string
CASE_SENSITIVE
= 'caseSensitive'
CHAR_SET
Character set used by the column (`charset`).
public
string
CHAR_SET
= 'charSet'
COLLATION
Collation used by the column (`collation`).
public
string
COLLATION
= 'collation'
COLUMN_ID
Ordinal position of the column within the table (`colid`).
public
string
COLUMN_ID
= 'columnId'
COLUMN_TYPE
Data type of the column (`coltype`), e.g. `INTEGER`, `VARCHAR`.
public
string
COLUMN_TYPE
= 'columnType'
DECIMAL
Number of decimal digits after the decimal point (`decimal`).
public
string
DECIMAL
= 'decimal'
DEFAULT_VALUE
Default value of the column (`dflt_value`).
public
string
DEFAULT_VALUE
= 'defaultValue'
FORMAT
Display format string used by the OpenEdge 4GL (`format`).
public
string
FORMAT
= 'format'
LABEL
Display label used by the OpenEdge 4GL (`label`).
public
string
LABEL
= 'label'
MANDATORY
Whether the column is mandatory in the 4GL schema (`mandatory`).
public
string
MANDATORY
= 'mandatory'
NULL_FLAG
Whether the column accepts the SQL NULL value (`nulls`/`nullFlag`).
public
string
NULL_FLAG
= 'nullFlag'
PRECISION
Numeric precision of the column (`precision`).
public
string
PRECISION
= 'precision'
RADIX
Numeric radix used by `precision` (`radix`).
public
string
RADIX
= 'radix'
SCALE
Numeric scale of the column (`scale`).
public
string
SCALE
= 'scale'
TABLE
Owning table of the column.
public
string
TABLE
= 'table'
WIDTH
Storage width of the column in bytes (`width`).
public
string
WIDTH
= 'width'