Properties uses trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short, trait:short

Aggregator trait that exposes every Progress OpenEdge SQL system catalog property key.

Tags

author

Marc Alcaraz (eKameleon)

since

1.0.0

Table of Contents

Constants

ABBREVIATE  : string = 'abbreviate'

Whether the index entry is stored in abbreviated form (`abbreviate`).

ALTER  : string = 'alter'

`ALTER` privilege flag (table-level).

ASC_DESC  : string = 'ascDesc'

Sort direction of the indexed column: ascending or descending (`asc_desc`).

BASE_TABLE  : string = 'baseTable'

Name of the table (or view) that the synonym refers to (`basetbl`).

BASE_TABLE_OWNER  : string = 'baseTableOwner'

Owner (SQL schema) of the referenced base table (`basetblowner`).

CASE_SENSITIVE  : string = 'caseSensitive'

Whether the column comparison is case sensitive (`case-sensitive`).

CHAR_SET  : string = 'charSet'

Character set used by the column (`charset`).

CHECK_OPTION  : string = 'checkOption'

Whether the view is a `WITH CHECK OPTION` view (`checkopt`).

CHECK_TEXT  : string = 'checkText'

SQL expression of a `CHECK` constraint (`SYS_CHK_CONSTRS.chktext`).

COLLATION  : string = 'collation'

Collation used by the column (`collation`).

COLUMN  : string = 'column'

Column name participating in the constraint (`SYS_KEYCOL_USAGE.col` / `SYS_CHKCOL_USAGE.col`).

COLUMN_ID  : string = 'columnId'

Ordinal position of the column within the table (`colid`).

COLUMN_LENGTH  : string = 'columnLength'

Maximum storage length of the data type, in bytes (`col_len`).

COLUMN_TYPE  : string = 'columnType'

Data type of the column (`coltype`), e.g. `INTEGER`, `VARCHAR`.

COLUMNS  : string = 'columns'

Collection of columns owned by this table (denormalized convenience key).

CONSTRAINT_NAME  : string = 'constraintName'

Name of the constraint (`constrname`).

CONSTRAINT_OWNER  : string = 'constraintOwner'

Owner (SQL schema) of the constraint (`constrowner`).

CONSTRAINT_TYPE  : string = 'constraintType'

Constraint type (`constrtype`): `P` (primary key), `U` (unique), `F` (foreign key) or `C` (check).

CREATION_DATE  : string = 'creationDate'

Creation timestamp of the catalog entry (`crdate`).

CREATOR  : string = 'creator'

Identifier of the SQL user that created the entry (`creator`).

CYCLE  : string = 'cycle'

Whether the sequence cycles back to its minimum once `maxValue` is reached (`cycle`).

DATA_TYPE_PRECISION  : string = 'dataTypePrecision'

Default numeric precision of the data type (`precision`).

DATA_TYPE_RADIX  : string = 'dataTypeRadix'

Numeric radix used by `dataTypePrecision` (`radix`).

DBA_ACCESS  : string = 'dbaAccess'

Whether the user has DBA privilege (`dba_acc`).

DECIMAL  : string = 'decimal'

Number of decimal digits after the decimal point (`decimal`).

DEFAULT_VALUE  : string = 'defaultValue'

Default value of the column (`dflt_value`).

DEFERRABILITY  : string = 'deferrability'

Deferrability mode of the constraint (`deferrability`).

DELETE  : string = 'delete'

`DELETE` privilege flag (table-level).

DELETE_RULE  : string = 'deleteRule'

`DELETE` referential action (`delete_rule`): `C` (cascade), `N` (set null), `D` (set default), `R` (restrict) or `A` (no action).

DESCRIPTION  : string = 'description'

Free-form description of the catalog entry (`description`/`remarks`).

EVENT  : string = 'event'

Trigger event: `I` (INSERT), `U` (UPDATE) or `D` (DELETE) (`event`).

FIELD_NUMBER  : string = 'fieldNumber'

Ordinal field number within the index definition (`fld_no`).

FOR_EACH  : string = 'forEach'

Granularity flag: `R` (FOR EACH ROW) or `S` (FOR EACH STATEMENT) (`for_each`).

FORMAT  : string = 'format'

Display format string used by the OpenEdge 4GL (`format`).

GRANTEE  : string = 'grantee'

SQL user name receiving the privileges (`grantee`).

GRANTOR  : string = 'grantor'

Identifier of the user that granted the privileges (`grantor`).

ID  : string = 'id'

Internal numeric identifier assigned by OpenEdge to the object.

INCREMENT  : string = 'increment'

Increment between two successive values (`increment`).

INDEX  : string = 'index'

`INDEX` privilege flag (table-level).

INDEX_OWNER  : string = 'indexOwner'

Owner (SQL schema) of the index itself (`idxowner`).

INDEX_SEQUENCE  : string = 'indexSequence'

Sequence (rank) of the column inside the index (`idxseq`).

INDEX_TYPE  : string = 'indexType'

Index type discriminator (`idxtype`): `U` for unique, `D` for duplicates.

INITIAL_VALUE  : string = 'initialValue'

Initial value of the sequence (`initial`).

INSERT  : string = 'insert'

`INSERT` privilege flag (table-level).

KEY_SEQUENCE  : string = 'keySequence'

Position of the column within a multi-column key (`keyseq`).

LABEL  : string = 'label'

Display label used by the OpenEdge 4GL (`label`).

MANDATORY  : string = 'mandatory'

Whether the column is mandatory in the 4GL schema (`mandatory`).

MATCH_TYPE  : string = 'matchType'

`MATCH` mode of a referential constraint (`match_type`).

MAX_VALUE  : string = 'maxValue'

Maximum value of the sequence (`maxval`).

MIN_VALUE  : string = 'minValue'

Minimum value of the sequence (`minval`).

NAME  : string = 'name'

Name of the catalog entry (table, column, index, view, sequence, …).

NULL_FLAG  : string = 'nullFlag'

Whether the column accepts the SQL NULL value (`nulls`/`nullFlag`).

NUMBER_OF_ARGUMENTS  : string = 'numberOfArguments'

Number of input/output parameters declared by the procedure (`numargs`).

NUMBER_OF_COMPONENTS  : string = 'numberOfComponents'

Total number of indexed components (`numcomp`).

NUMBER_OF_ROWS  : string = 'numberOfRows'

Number of rows in the table at the last statistics update (`numrows`).

OWNER  : string = 'owner'

Owner (SQL schema) of the catalog entry (`owner`/`tblowner`).

PERCENT_TOUCHED  : string = 'percentTouched'

Percentage of the table that has been touched since the last statistics update (`pcttouched`).

PRECISION  : string = 'precision'

Numeric precision of the column (`precision`).

PRIMARY  : string = 'primary'

Whether this index is the primary index of the table.

PROCEDURE_ID  : string = 'procedureId'

Stable identifier assigned to the procedure (`procid`).

PROCEDURE_OWNER  : string = 'procedureOwner'

Owner (SQL schema) of the procedure (`procowner`).

PROCEDURE_TEXT  : string = 'procedureText'

SQL source text of the procedure (`text` / `SYSPROCTEXT`).

RADIX  : string = 'radix'

Numeric radix used by `precision` (`radix`).

RECORD_SIZE  : string = 'recordSize'

Average record size in bytes (`recsize`).

REFERENCES  : string = 'references'

`REFERENCES` privilege flag.

REMARKS  : string = 'remarks'

Free-form remarks attached to the procedure (`remarks`).

RESOURCE_ACCESS  : string = 'resourceAccess'

Whether the user has RESOURCE privilege (`res_acc`).

RETURN_TYPE  : string = 'returnType'

Return type of the procedure, when applicable (`rettype`).

SCALE  : string = 'scale'

Numeric scale of the column (`scale`).

SELECT  : string = 'select'

`SELECT` privilege flag.

SEQUENCE_OWNER  : string = 'sequenceOwner'

Owner (SQL schema) of the sequence (`seqowner`).

STATUS  : string = 'status'

Lifecycle status flag of the catalog entry (`status`).

SYNONYM_OWNER  : string = 'synonymOwner'

Owner (SQL schema) of the synonym itself (`synowner`).

TABLE  : string = 'table'

Owning table of the column.

TABLE_ATTRIBUTES  : string = 'tableAttributes'

Bitmask of table attributes (`tblattributes`).

TABLE_OWNER  : string = 'tableOwner'

Owner of the referenced table (`tblowner`).

TEXT_LENGTH  : string = 'textLength'

Total length in characters of the view definition text (`textlen`).

TIMING  : string = 'timing'

Trigger timing: `B` (BEFORE) or `A` (AFTER) (`when`).

TRIGGER_OWNER  : string = 'triggerOwner'

Owner (SQL schema) of the trigger (`trigowner`).

TRIGGER_TEXT  : string = 'triggerText'

SQL source text of the trigger body (`trigtext`).

TYPE  : string = 'type'

Type discriminator of the catalog entry (e.g. `T`, `V`, `S` for tables).

TYPE_CODE  : string = 'typeCode'

Numeric SQL type code identifying the data type (`typecode`).

TYPE_NAME  : string = 'typeName'

Canonical SQL name of the data type (`typename`).

UNIQUE  : string = 'unique'

Whether the index enforces uniqueness (`unique`).

UNIQUE_NAME  : string = 'uniqueName'

Identifier of the unique/primary key constraint referenced by a foreign key (`uniquename`).

UNIQUE_OWNER  : string = 'uniqueOwner'

Owner (SQL schema) of the referenced unique/primary key constraint (`uniqueowner`).

UPDATE  : string = 'update'

`UPDATE` privilege flag.

UPDATE_RULE  : string = 'updateRule'

`UPDATE` referential action (`update_rule`): `C` (cascade), `N` (set null), `D` (set default), `R` (restrict) or `A` (no action).

UPDATE_STATS  : string = 'updateStats'

Timestamp of the last automatic statistics update (`updstats`).

VIEW_TEXT  : string = 'viewText'

`CREATE VIEW` SQL statement that defines the view (`text`).

WIDTH  : string = 'width'

Storage width of the column in bytes (`width`).