[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
This view augments information available in sprockit.Resource.
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| RL1 | ResourceId | INT | From sprockit.Resource | |
| ProcessId | INT | From sprockit.Resource | ||
| IsInput | BIT | From sprockit.Resource | ||
| DbName | NVARCHAR(128) | From sprockit.Resource | ||
| SchemaName | NVARCHAR(128) | From sprockit.Resource | ||
| ResourceName | NVARCHAR(128) | From sprockit.Resource | ||
| FqResourceName | NVARCHAR(392) | From sprockit.Resource | ||
| ResourceType | VARCHAR(2) | The object type of this resource. | Object type values are as defined for sys.objects.[type]. |
|
| IsStoredQuery | BIT | Indicates whether the resource (in fact any object of this [ResourceType]) is a stored query. | e.g. a view or a function | |
| ObjectId | INT | The database-scoped object ID of this resource object. | If applicable | |
| IndexRebuildMode | TINYINT | From sprockit.Resource where specified, otherwise as indicated by Sprockit's DefaultIndexRebuildMode property. | Non-NULL if [IsInput] = 0, otherwise NULL | |
| IndexRebuild Fragmentation Threshold | TINYINT | From sprockit.Resource where specified, otherwise as indicated by Sprockit's DefaultIndexRebuild FragmentationThreshold property. | Non-NULL if [IsInput] = 0, otherwise NULL |
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| RL1 | ResourceId | sprockit.Resource | ResourceId |
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.