%TSQL.sys.objects

Class %TSQL.sys.objects Extends %Persistent [ SqlRowIdPrivate, StorageStrategy = SQLStorage, System = 4 ]

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

READONLY

Parameter READONLY = 1;

Properties

schema

Property schema As %String(MAXLEN = 128) [ SqlColumnNumber = 10 ];

Name of the schema the object resides in

name

Property name As %String(MAXLEN = 128) [ SqlColumnNumber = 2 ];

Object name

parentobjname

Property parentobjname As %String(MAXLEN = 128) [ SqlColumnNumber = 11, SqlFieldName = parent_obj_name ];

Parent Object name Object name of the parent_obj. If parent_obj = 0, parent_obj_name = name

id

Property id As %Integer [ SqlColumnNumber = 3 ];

Object id

parentobj

Property parentobj As %Integer [ SqlColumnNumber = 5, SqlFieldName = parent_obj ];

Object identification number of parent object (for example, the table ID if a trigger or constraint).

type

Property type As %String(MAXLEN = 2) [ SqlColumnNumber = 6 ];

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

deltrig

Property deltrig As %Integer [ SqlColumnNumber = 7 ];

Stored procedure ID of a delete trigger if the entry is a table. Table ID if the entry is a trigger.

instrig

Property instrig As %Integer [ SqlColumnNumber = 8 ];

Stored procedure ID of a table's insert trigger if the entry is a table

updtrig

Property updtrig As %Integer [ SqlColumnNumber = 9 ];

Stored procedure ID of a table's update trigger if the entry is a table