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'