reference.RepoObject_ReferenceTree_30_0 - V
type: V ( view ), modify_date: 2021-12-16 11:41:19
RepoObject_guid: D5E2805C-FDF5-EB11-850C-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObject_ReferenceTree_30_0
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-Referencing_guid]; uniqueidentifier
-
[column-Referenced_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
Column Details
_
sql_modules_definition
reference.RepoObject_ReferenceTree_30_0 - V script
CREATE View reference.RepoObject_ReferenceTree_30_0
As
Select
tree.RepoObject_guid
, tree.Referencing_guid
, tree.Referenced_guid
, Referencing_Depth = Min ( tree.Referencing_Depth )
, Referencing_fullname = Max ( tree.Referencing_fullname )
, Referencing_fullname2 = Max ( tree.Referencing_fullname2 )
, Referencing_type = Max ( tree.Referencing_type )
, Referenced_Depth = Min ( tree.Referenced_Depth )
, Referenced_fullname = Max ( tree.Referenced_fullname )
, Referenced_fullname2 = Max ( tree.Referenced_fullname2 )
, Referenced_type = Max ( tree.Referenced_type )
From
repo.RepoObject_gross As ro
Cross Apply reference.ftv_RepoObject_ReferenceTree ( ro.RepoObject_guid, 30, 0 ) As tree
Where
ro.is_in_reference = 1
Group By
tree.RepoObject_guid
, tree.Referencing_guid
, tree.Referenced_guid