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.
| Column Name | Data Type | Description |
|---|---|---|
TypeName |
VT_BSTR |
The name of the user-defined type. |
DataType |
VT_BSTR |
The data type of the user-defined type. |
Description |
VT_BSTR |
The description of the user-defined type. |
StoreFieldQuality |
VT_BOOL |
Indicates whether the field-level quality is stored. |
NumberofFields |
VT_I4 |
The number of fields a user-defined type contains. |
NumberofTagReferences |
VT_I4 |
The number of tags with which a user-defined type is associated. |
AdministratorSecurityGroup |
VT_BSTR |
The security group to which the user-defined type belongs. |
LastModifiedUser |
VT_BSTR |
Indicates which user last modified the user-defined type. |
LastModifiedTime |
VT_DBTimeStamp |
Indicates the last time the user-defined type was modified. |
RowCount |
VT_I4 |
Indicates 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 ihuserdefinedtypesExample 2: Retrieve a User-Defined Type By Name
SELECT * FROM ihuserdefinedtypes WHERE typename LIKE New