Common
Property keys shared by several OpenEdge SQL system catalog tables.
These constants centralize names that appear with the same semantics in multiple SYS% tables, such as the owner of a database object, the creator, the creation date or a generic description.
Tags
Table of Contents
Constants
- CREATION_DATE : string = 'creationDate'
- Creation timestamp of the catalog entry (`crdate`).
- CREATOR : string = 'creator'
- Identifier of the SQL user that created the entry (`creator`).
- DESCRIPTION : string = 'description'
- Free-form description of the catalog entry (`description`/`remarks`).
- ID : string = 'id'
- Internal numeric identifier assigned by OpenEdge to the object.
- NAME : string = 'name'
- Name of the catalog entry (table, column, index, view, sequence, …).
- OWNER : string = 'owner'
- Owner (SQL schema) of the catalog entry (`owner`/`tblowner`).
- STATUS : string = 'status'
- Lifecycle status flag of the catalog entry (`status`).
- TABLE : string = 'table'
- Owning table reference (`tbl`/`tblname`).
- TABLE_OWNER : string = 'tableOwner'
- Owner of the referenced table (`tblowner`).
- TYPE : string = 'type'
- Type discriminator of the catalog entry (e.g. `T`, `V`, `S` for tables).
Constants
CREATION_DATE
Creation timestamp of the catalog entry (`crdate`).
public
string
CREATION_DATE
= 'creationDate'
CREATOR
Identifier of the SQL user that created the entry (`creator`).
public
string
CREATOR
= 'creator'
DESCRIPTION
Free-form description of the catalog entry (`description`/`remarks`).
public
string
DESCRIPTION
= 'description'
ID
Internal numeric identifier assigned by OpenEdge to the object.
public
string
ID
= 'id'
NAME
Name of the catalog entry (table, column, index, view, sequence, …).
public
string
NAME
= 'name'
OWNER
Owner (SQL schema) of the catalog entry (`owner`/`tblowner`).
public
string
OWNER
= 'owner'
STATUS
Lifecycle status flag of the catalog entry (`status`).
public
string
STATUS
= 'status'
TABLE
Owning table reference (`tbl`/`tblname`).
public
string
TABLE
= 'table'
TABLE_OWNER
Owner of the referenced table (`tblowner`).
public
string
TABLE_OWNER
= 'tableOwner'
TYPE
Type discriminator of the catalog entry (e.g. `T`, `V`, `S` for tables).
public
string
TYPE
= 'type'