Types 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.]
Stores .NET Framework type information for managed constructs, such as classes, values, enumerations, delegates, and interfaces. This is the generalized extent in the Types/TypeDefinitions/TypeReferences hierarchy.
Fields
The following table lists the fields in the Types table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
yes |
The Modeling Services Folder associated with the type. References the [Repository.Item].[FoldersTable] view. |
|
Id |
bigint |
yes |
The Modeling Services Folder that is associated with the type. |
Module |
bigint |
yes |
The module that contains the type. References the [System_Runtime].[Modules] view. |
Name |
nvarchar(max) |
yes |
The name of the type. |
IsReference |
bit |
yes |
A bit flag that indicates that the type is a type reference. If this flag is 0, a corresponding entry for this type exists in [System_Runtime].[TypeDefinitions]. Otherwise, a corresponding entry exists in [System_Runtime].[TypeReferences]. |
QualifiedName |
nvarchar(max) |
yes |
The fully-qualified name of this type, without assembly information. |
Hash_QualifiedName |
int |
yes |
Infrastructure. Do not directly use or access this field. This is a readonly, computed column. |