Skip to main content

%TSQL.sys.objects

persistent class %TSQL.sys.objects extends %Library.Persistent

SQL Table Name: %TSQL_sys.objects

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.

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: 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 methods: deltrigDisplayToLogical(), deltrigGet(), deltrigIsValid(), deltrigLogicalToDisplay(), deltrigNormalize(), deltrigSet()
property id as %Integer [ Required ];
Object id
Property methods: idDisplayToLogical(), idGet(), idIsValid(), idLogicalToDisplay(), idNormalize(), idSet()
property instrig as %Integer;
Stored procedure ID of a table's insert trigger if the entry is a table
Property methods: instrigDisplayToLogical(), instrigGet(), instrigIsValid(), instrigLogicalToDisplay(), instrigNormalize(), instrigSet()
property name as %String (MAXLEN = 128);
Object name
Property methods: nameDisplayToLogical(), nameGet(), nameIsValid(), nameLogicalToDisplay(), nameLogicalToOdbc(), nameNormalize(), nameSet()
property parentobj as %Integer [ SqlFieldName = parent_obj ];
Object identification number of parent object (for example, the table ID if a trigger or constraint).
Property methods: parentobjDisplayToLogical(), parentobjGet(), parentobjIsValid(), parentobjLogicalToDisplay(), parentobjNormalize(), parentobjSet()
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 methods: parentobjnameDisplayToLogical(), parentobjnameGet(), parentobjnameIsValid(), parentobjnameLogicalToDisplay(), parentobjnameLogicalToOdbc(), parentobjnameNormalize(), parentobjnameSet()
property schema as %String (MAXLEN = 128);
Name of the schema the object resides in
Property methods: schemaDisplayToLogical(), schemaGet(), schemaIsValid(), schemaLogicalToDisplay(), schemaLogicalToOdbc(), schemaNormalize(), schemaSet()
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 methods: typeDisplayToLogical(), typeGet(), typeIsValid(), typeLogicalToDisplay(), typeLogicalToOdbc(), typeNormalize(), typeSet()
property updtrig as %Integer;
Stored procedure ID of a table's update trigger if the entry is a table
Property methods: updtrigDisplayToLogical(), updtrigGet(), updtrigIsValid(), updtrigLogicalToDisplay(), updtrigNormalize(), updtrigSet()

Indexes

index (IDKEYIndex on id) [IdKey, PrimaryKey, Type = key, Unique];
Index methods: IDKEYIndexCheck(), IDKEYIndexDelete(), IDKEYIndexExists(), IDKEYIndexOpen(), IDKEYIndexSQLCheckUnique(), IDKEYIndexSQLExists(), IDKEYIndexSQLFindPKeyByConstraint(), IDKEYIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: SQLStorage

Maps: 2

  • Map number 1 is named Master

    thismap.Global: ^oddTSQL

  • Map number 2 is named SchemaNameIndex

    thismap.Global: ^oddSQL

  • ^oddTSQL({id})
    =
    Node Delimiter Piece Name
    1 schema
    2 parent_obj_name
    3 type
    4 parent_obj
    5 name
    6 deltrig
    7 instrig
    8 updtrig
    ^oddSQL({schema},{parent_obj_name},"tsql",1,{id})
    =
FeedbackOpens in a new tab