Class Reference
IRIS for UNIX 2019.3
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [%TSQL] >  [sys] >  [objects]
Private  Storage   

persistent class %TSQL.sys.objects extends %Persistent

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. This table is in each database.


Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 9 1


deltrig id instrig name parentobj
parentobjname schema type updtrig

%AddToSaveSet %AddToSyncSet %BuildIndicesAsync %BuildIndicesAsyncResponse
%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


• 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 deltrig as %Integer;
Stored procedure ID of a delete trigger if the entry is a table. Table ID if the entry is a trigger.
• property id as %Integer;
Object id
• property instrig as %Integer;
Stored procedure ID of a table's insert trigger if the entry is a table
• property name as %String(MAXLEN=128);
Object name
• property parentobj as %Integer [ SqlFieldName = parent_obj ];
Object identification number of parent object (for example, the table ID if a trigger or constraint).
• property parentobjname as %String(MAXLEN=128) [ SqlFieldName = parent_obj_name ];
Parent Object name Object name of the parent_obj. If parent_obj = 0, parent_obj_name = name
• property schema as %String(MAXLEN=128);
Name of the schema the object resides in
• property type as %String(MAXLEN=2);
Object type. Can be one of these values: D = default K = PRIMARY KEY or UNIQUE constraint L = log P = procedure PR = prepare objects (created by Dynamic SQL) R = rule RI = referential constraint S = system table TR = trigger U = user table V = view XP = extended stored procedure
• property updtrig as %Integer;
Stored procedure ID of a table's update trigger if the entry is a table


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

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