sprockit.uvw_Resource
[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
This view augments information available in sprockit.Resource.
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| PK, RL1 | ResourceId | INT | From sprockit.Resource | |
| DbName | NVARCHAR(128) | From sprockit.Resource | ||
| SchemaName | NVARCHAR(128) | From sprockit.Resource | ||
| ResourceName | NVARCHAR(128) | From sprockit.Resource | ||
| FqResourceName | NVARCHAR(392) | The fully-qualified (three-part) name of the resource. | Combines [DbName], [SchemaName], [ResourceName] | |
| ResourceUid | INT | Unique identifier for a resource object | [ResourceId] identifies an object as an input or output of a specific process (indicated by [ProcessId]). [ResourceUid] uniquely identifies the underlying object; each occurrence in the view of a given combination of [DbName], [SchemaName] and [ResourceName] has a different [ResourceId] value but the same value of [ResourceUid]. | |
| ProcessId | INT | From sprockit.Resource | ||
| FqProcessName | NVARCHAR(392) | The fully-qualified (three-part) name of the process indicated by [ProcessId]. | From sprockit.Process | |
| IsInput | BIT | From sprockit.Resource | ||
| ResourceType | VARCHAR(2) | The object type of this resource. | Object type values are as defined for sys.objects.[type]. |
|
| ObjectId | INT | The database-scoped object ID of this resource object. | If applicable | |
| IsStoredQuery | BIT | Indicates whether the resource (in fact any object of this [ResourceType]) is a stored query. | A stored query is a view or a user-defined function. | |
| IndexRebuildMode | TINYINT | From sprockit.Resource where specified, otherwise as indicated by Sprockit's DefaultIndexRebuildMode property. | Present only in records with [IsInput] = 0 and [ResourceType] = 'U' or 'V' | |
| IndexRebuild Fragmentation Threshold | TINYINT | From sprockit.Resource where specified, otherwise as indicated by Sprockit's DefaultIndexRebuild FragmentationThreshold property. | Present only in records with [IsInput] = 0 and [ResourceType] = 'U' or 'V' |
Relationships
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
References to other tables
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| RL1 | ResourceId | sprockit.Resource | ResourceId |
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.
1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.