reference.RepoObject_ReferenceTree_referenced - V
type: V ( view ), modify_date: 2021-12-16 11:41:19
RepoObject_guid: 65CDA946-459D-EB11-84F6-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
4 |
|
|
||
5 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObject_ReferenceTree_referenced
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-Referenced_guid]; uniqueidentifier
-
[column-Referencing_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
sql_modules_definition
reference.RepoObject_ReferenceTree_referenced - V script
--bad performance
CREATE View reference.RepoObject_ReferenceTree_referenced
As
Select
tree.referenced_fullname
, tree.referenced_fullname2
, tree.Referenced_guid
, tree.referenced_is_DocsOutput
, tree.referenced_type
, tree.referencing_fullname
, tree.referencing_fullname2
, tree.Referencing_guid
, tree.referencing_type
, tree.referencing_is_DocsOutput
, tree.Referenced_Depth
, tree.Referencing_Depth
, tree.RepoObject_guid
From
repo.RepoObject_gross As ro
Cross Apply reference.ftv_RepoObject_ReferenceTree_referenced ( ro.RepoObject_guid, 100, 100 ) As tree
Where
ro.is_in_reference = 1sql