Files 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.]
Maps files to the assemblies that they contain. Note that this is not yet populated by the LoadAssembly.exe tool.
Fields
The following table lists the fields in the Files table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
yes |
The Modeling Services Folder that is associated with the file. References the [Repository.Item].[FoldersTable] view. |
|
Id |
bigint |
yes |
The identifier of the file. |
Assembly |
bigint |
yes |
The assembly that contains this file. References the [System_Runtime].[Assemblies] view. |
Name |
nvarchar(max) |
yes |
The name of the file. |
ContainsMetadata |
bit |
yes |
A bit flag that specifies whether the file is a secondary module in a multi-module assembly (1), or is a resource file (0). |
HashValue |
varbinary(max) |
yes |
The binary hash value of the file, computed from the file contents. |