%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
- %AddToSaveSet()
- %AddToSyncSet()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
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})
|
= |
|
^oddSQL({schema},{tabname},"tsql",1,{tabid})
|
= |
|