Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%XSQL] >  [Catalog] >  [Informix] >  [systables]
Private  Storage   

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.


Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 7 1


owner tabid tabname tabtype

%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


• parameter READONLY = 1;
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 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


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

Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.