You are here: Reference Information > SQL Reference Information > SQL System Tables > FIELDS System Table Description

FIELDS System Table Description

Description

Contains information about every field in every persistent table in the database.

Fields

Field Name Type Description
FIELD string Name of field, which is also the name of the column.
TABLENAME string Table name for this field/column.
SCHEMA string Schema name for the table for this field/column.
DOMAINNAME string If this column is defined as a SQL DOMAIN, this is the DOMAIN name. Otherwise, null.
DOMAINSCHEMA string If this column is defined as a SQL DOMAIN, this is the name of the schema for the DOMAIN. Otherwise, null.
COLLATIONSEQUENCE string If this column is a string type and a collation was specified, this is the name of the collation. Otherwise, null.
FIELDPOSITION integer This is the position of the field specifying the order in which the field was given in the original CREATE TABLE command. IDs will continue to be incremented by one in ascending order for any columns added by ALTER TABLE, despite any columns dropped by ALTER TABLE.
FIELDID integer This is the same as FIELDPOSITION.
DATATYPE integer Integer from ID in SYSTEM.DATATYPES for this column's data type.
LENGTH integer Length associated with the data type for this column. This is the precision assigned to a CHAR or BINARY type or the size in bytes of the type.
SCALE integer If the column is defined as a fixed precision numeric type, this is the scale. Otherwise, 0.
PRECISION integer If the column is defined as a fixed precision numeric, CHAR or BINARY type, this is the precision. Otherwise, this is the maximum precision possible for this type.
DISPLAY_SIZE integer Internal field used to help the nuosql client and other clients display data.
FLAGS integer

Flags specifying additional information about this column:

  • 1 = column is NOT_NULL
  • 2 = reserved for future use to flag Searchable
  • 4 = reserved for future use to flag Case Insensitive
  • 8 = column is defined as GENERATED ALWAYS AS IDENTITY, as opposed to GENERATED BY DEFAULT AS IDENTITY
DEFAULTVALUE string A default value given for the column when it is created.
REMARKS string Unused.
GENERATOR_SEQUENCE text Contains the name of the sequence, if the column has been defined as "GENERATED...AS IDENTITY". See column FLAGS for type of generation, always or by default.
ENUMERATION text Contains the textual labels for fields defined as ENUM data type.
CHARACTER_SET text Unused.
DECLARED_TYPE string The actual string for the type of the column parsed from the command that created the column (CREATE TABLE or ALTER TABLE).

Indexes

Primary Index: FIELDS..PRIMARY_KEY on fields: SCHEMA, TABLENAME, FIELD

Secondary Index: FIELDCOLLATIONSEQUENCENAME on field: COLLATIONSEQUENCE

Secondary Index: FIELDDOMAINNAME on fields: DOMAINNAME, DOMAINSCHEMA