sprockit.uvw_Resource

This view augments information available in sprockit.Resource.

	Column name¹⁾	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.

¹⁾

Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.

Columns