Class %XSQL.Catalog.Informix.systables

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

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.

Inventory

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	7			1

Summary

Properties
owner	tabid	tabname	tabtype

Methods
%%OIDGet	%AddToSaveSet	%AddToSyncSet	%BuildIndices
%CheckUnique	%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	%KillExtent	%LockExtent
%LockId	%New	%NormalizeObject	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDetermineClass	%Open
%OpenId	%OriginalNamespace	%PackageName	%PurgeIndices
%Reload	%RemoveFromSaveSet	%ResolveConcurrencyConflict	%RollBack
%Save	%SaveDirect	%SerializeObject	%SetModified
%SortBegin	%SortEnd	%SyncObjectIn	%SyncTransport
%UnlockExtent	%UnlockId	%ValidateObject

Parameters

• parameter READONLY = 1;

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 tabid as %Integer;

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 tabname as %String(MAXLEN=128);

Name of table, view, or synonym

• 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

Indices

• index (IDKEYIndex on tabid) [IdKey,PrimaryKey,Unique];


[BASEXML] > [%XSQL] > [Catalog] > [Informix] > [systables]		Private Storage