Skip to main content


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


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.


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()


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

Inherited Members

Inherited Methods


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
FeedbackOpens in a new tab