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