Class Reference
%TSQL.sys.objects
Server:irisdocs2
Instance:IRISLATEST
User:UnknownUser
 
-
  [%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.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 9 1


Summary

Properties
deltrig id instrig name parentobj
parentobjname schema type updtrig

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


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

Indices

•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.