Skip to main content

%TSQL.sys.usertypes

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

SQL Table Name: %TSQL_sys.usertypes

Contains one row for each user-defined data type.

Property Inventory

Method Inventory

Properties

property allownulls as %Boolean;
Property methods: allownullsDisplayToLogical(), allownullsGet(), allownullsGetStored(), allownullsIsValid(), allownullsLogicalToDisplay(), allownullsNormalize(), allownullsSet()
property ident as %TinyInt;
Property methods: identDisplayToLogical(), identGet(), identGetStored(), identIsValid(), identLogicalToDisplay(), identNormalize(), identSet()
property length as %Integer [ Transient ];
Physical length of data type
Property methods: lengthCompute(), lengthDisplayToLogical(), lengthGet(), lengthIsValid(), lengthLogicalToDisplay(), lengthNormalize(), lengthSQLCompute(), lengthSet(), lengthSetT()
property name as %String [ Required ];
Property methods: nameDisplayToLogical(), nameGet(), nameGetStored(), nameIsValid(), nameLogicalToDisplay(), nameLogicalToOdbc(), nameNormalize(), nameSet()
property type as %String [ Required ];
Property methods: typeDisplayToLogical(), typeGet(), typeGetStored(), typeIsValid(), typeLogicalToDisplay(), typeLogicalToOdbc(), typeNormalize(), typeSet()
property uid as %String;
Property methods: uidDisplayToLogical(), uidGet(), uidGetStored(), uidIsValid(), uidLogicalToDisplay(), uidLogicalToOdbc(), uidNormalize(), uidSet()

Methods

final classmethod GetIRISDatatype(systype As %String, ByRef identity As %TinyInt, allownulls As %TinyInt) as %String

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (NameIndex on name) [Data = name, Unique];
Index methods: NameIndexCheck(), NameIndexCheckUnique(), NameIndexDelete(), NameIndexExists(), NameIndexOpen(), NameIndexSQLCheckUnique(), NameIndexSQLExists(), NameIndexSQLFindPKeyByConstraint(), NameIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: Storage (%TSQL.sys.usertypes)

^rINDEXSQL("tsql","systypes",1)(ID)
=
name
type
ident
allownulls
uid
FeedbackOpens in a new tab