ihFields Table
The ihFields table contains information about field elements that are specified in user-defined data types. The following table describes the columns of the ihFields table.
| Column Name | Data Type | Description |
|---|---|---|
TypeName |
VT_BSTR |
The name of the user-defined type. |
FieldName |
VT_BSTR |
The name of the field. |
Description |
VT_BSTR |
The description of the field. |
FieldValueDataType |
VT_BSTR |
The data type of the field. |
MasterField |
VT_BOOL |
Indicates whether the field is a master field. |
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. |
ihFields Examples
Sample SQL statements for the ihFields table are outlined in the following examples.
Example: Retrieve All Fields for a Specific Type
SELECT * FROM ihfields WHERE typename='MyUserDefinedType'