Fields Table (System_Runtime Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Provides field information for types in [System_Runtime].[Types].
Fields
The following table lists the fields in the Fields table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
yes |
The Modeling Services Folder that is associated with the field. References the [Repository.Item].[FoldersTable] view. |
|
Id |
bigint |
yes |
The identifier of the field. |
DeclaringType |
bigint |
yes |
The type definition that contains the field. References the [System_Runtime].[TypeDefinitions] view. |
Name |
nvarchar(max) |
yes |
The name of the field. |
Access |
smallint |
yes |
An enumeration value between 0 and 6 that describes the access restrictions for the field. These numeric values are equivalent to compiler, private, family and assembly, assembly, family, family or assembly, and public, respectively. |
Default |
sql_variant |
The default value for the field. Note that this is not yet populated by the LoadAssembly.exe tool. |
|
IsStatic |
bit |
yes |
A bit flag that indicates that the field is static. |
IsToolSpecialName |
bit |
yes |
A bit flag that specifies that the field name is special and has a reserved use by tools other than the common language runtime (CLR). |
IsRuntimeSpecialName |
bit |
yes |
A bit flag that specifies that the field name is special and has a reserved use by the common language runtime (CLR). |
IsReadOnly |
bit |
yes |
A bit flag that specifies that the field is read-only. |
IsConstant |
bit |
yes |
A bit flag that specifies that the field is a constant. |
IsSerialized |
bit |
yes |
A bit flag that specifies that the field can be serialized. |
OffsetBytes |
int |
The number of bytes to offset this field in the layout of the containing type. |
|
Type |
bigint |
yes |
The type signature of the field. References the [System_Runtime].[TypeSignatures] view. |
MarshaledAs |
nvarchar(max) |
Specifies what unmanaged type the field should be marshaled as. If a custom marshaler is specified, this field contains the name of the custom marshaler and its cookie. |
|
MarshaledArrayElementType |
nvarchar(max) |
If this field is marshaled as an ECMA-335 native array (LPArray), this will contain its element type, in the same format as MarshaledAs. |
|
MarshaledArraySizeParameterIndex |
int |
The index to the parameter in the method that provides the number of elements in a marshaled ECMA-335 native array (LPArray). Not valid for fields. |
|
MarshaledArraySizeConst |
int |
The number of elements in a marshaled ECMA-335 native array (LPArray). |
|
InitialValue |
nvarchar(max) |
The initial value of a constant field. |
|
Documentation |
nvarchar(max) |
The XML Document fragment for the field. Note that this is not yet populated by the LoadAssembly.exe tool. |
|
Attributes |
nvarchar(max) |
The custom attributes for the field. Note that this is not yet populated by the LoadAssembly.exe tool. |