Skip to main content

%XSQL.Catalog.Informix.systables

persistent class %XSQL.Catalog.Informix.systables extends %Library.Persistent

SQL Table Name: %XSQL_Catalog_Informix.systables

The systables system catalog table describes each table in the database. It contains one row for each table, view, or synonym that is defined in the database. This includes all database tables and the system catalog tables.

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property owner as %String (MAXLEN = 128) [ Transient ];
Owner of table (user informix for system catalog tables and user name for database tables)
Property methods: ownerCompute(), ownerDisplayToLogical(), ownerGet(), ownerIsValid(), ownerLogicalToDisplay(), ownerLogicalToOdbc(), ownerNormalize(), ownerSQLCompute(), ownerSet(), ownerSetT()
property tabid as %Integer [ Required ];
Tblspace identifier (similar to tabid) Property partnum As %Integer [ SqlColumnNumber = 4 ]; System-assigned sequential ID number (system tables: 1 through 24, user tables: 100 through nnn)
Property methods: tabidDisplayToLogical(), tabidGet(), tabidIsValid(), tabidLogicalToDisplay(), tabidNormalize(), tabidSet()
property tabname as %String (MAXLEN = 128);
Name of table, view, or synonym
Property methods: tabnameDisplayToLogical(), tabnameGet(), tabnameIsValid(), tabnameLogicalToDisplay(), tabnameLogicalToOdbc(), tabnameNormalize(), tabnameSet()
property tabtype as %String (MAXLEN = 1) [ Transient ];
Table type: 'T' = Table 'V' = View 'P' = Private synonym 'P' = Synonym (in an ANSI-compliant database) 'S' = Synonym
Property methods: tabtypeCompute(), tabtypeDisplayToLogical(), tabtypeGet(), tabtypeIsValid(), tabtypeLogicalToDisplay(), tabtypeLogicalToOdbc(), tabtypeNormalize(), tabtypeSQLCompute(), tabtypeSet(), tabtypeSetT()

Indexes

index (IDKEYIndex on tabid) [IdKey, PrimaryKey, Type = key, Unique];
Index methods: IDKEYIndexCheck(), IDKEYIndexDelete(), IDKEYIndexExists(), IDKEYIndexOpen(), IDKEYIndexSQLCheckUnique(), IDKEYIndexSQLExists(), IDKEYIndexSQLFindPKeyByConstraint(), IDKEYIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheSQLStorage

Maps: 2

  • Map number 1 is named Master

    thismap.Global: ^oddTSQL

  • Map number 2 is named SchemaNameIndex

    thismap.Global: ^oddSQL

  • ^oddTSQL({tabid})
    =
    Node Delimiter Piece Name
    1 schema
    2 tabname
    3 tabtype_internal
    ^oddSQL({schema},{tabname},"tsql",1,{tabid})
    =
FeedbackOpens in a new tab