ihUserDefinedTypes Table

The ihUserDefinedTypes table contains information about user-defined data types in the system.

Use this table to see the set of types and get information about each field in the data type.

The following table describes the columns of the ihUserDefinedTypes table.

Table 1. ihUserDefinedTypes Table
Column NameData TypeDescription
TypeNameVT_BSTRThe name of the user-defined type.
DataTypeVT_BSTRThe data type of the user-defined type.
DescriptionVT_BSTRThe description of the user-defined type.
StoreFieldQualityVT_BOOLIndicates whether the field-level quality is stored.
NumberofFieldsVT_I4The number of fields a user-defined type contains.
NumberofTagReferencesVT_I4The number of tags with which a user-defined type is associated.
AdministratorSecurityGroupVT_BSTRThe security group to which the user-defined type belongs.
LastModifiedUserVT_BSTRIndicates which user last modified the user-defined type.
LastModifiedTimeVT_DBTimeStampIndicates the last time the user-defined type was modified.
RowCountVT_I4Indicates the maximum number of rows that can be returned. A value of 0 indicates that there is no limit to the number of rows returned.

ihUserDefinedTypes Examples

Sample SQL statements for the ihUserDefinedType table are outlined in the following examples.

Example 1: Retrieve All User-Defined Types

SELECT * FROM ihuserdefinedtypes

Example 2: Retrieve a User-Defined Type By Name

SELECT * FROM ihuserdefinedtypes WHERE typename LIKE New