reference.RepoObject_reference_union - V
type: V ( view ), modify_date: 2022-01-22 00:37:12
RepoObject_guid: 6390291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
References
Indexes
PK_RepoObject_reference_union
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObject_guid]; uniqueidentifier
-
[column-referencing_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
Column Details
sql_modules_definition
reference.RepoObject_reference_union - V script
CREATE View reference.RepoObject_reference_union
As
Select
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, T1.referenced_entity_name
, T1.referenced_fullname
, T1.referenced_id
, T1.referenced_schema_name
, T1.referenced_type
, referenced_external_AntoraComponent = Null
, referenced_external_AntoraModule = Null
, referenced_is_external = 0
, T1.referencing_entity_name
, T1.referencing_fullname
, T1.referencing_id
, T1.referencing_schema_name
, T1.referencing_type
, referencing_external_AntoraComponent = Null
, referencing_external_AntoraModule = Null
, referencing_is_external = 0
, T1.InformationSource
, one = 1
From
reference.RepoObject_reference_SqlExpressionDependencies As T1
Union All
Select
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, T1.referenced_entity_name
, T1.referenced_fullname
, T1.referenced_id
, T1.referenced_schema_name
, T1.referenced_type
, referenced_external_AntoraComponent = Null
, referenced_external_AntoraModule = Null
, referenced_is_external = 0
, T1.referencing_entity_name
, T1.referencing_fullname
, T1.referencing_id
, T1.referencing_schema_name
, T1.referencing_type
, referencing_external_AntoraComponent = Null
, referencing_external_AntoraModule = Null
, referencing_is_external = 0
, T1.InformationSource
, one = 1
From
reference.RepoObject_reference_persistence As T1
Union All
Select
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, T1.referenced_entity_name
, T1.referenced_fullname
, T1.referenced_id
, T1.referenced_schema_name
, T1.referenced_type
, referenced_external_AntoraComponent = Null
, referenced_external_AntoraModule = Null
, referenced_is_external = 0
, T1.referencing_entity_name
, T1.referencing_fullname
, T1.referencing_id
, T1.referencing_schema_name
, T1.referencing_type
, referencing_external_AntoraComponent = Null
, referencing_external_AntoraModule = Null
, referencing_is_external = 0
, T1.InformationSource
, one = 1
From
reference.RepoObject_reference_virtual As T1
Union All
Select
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, T1.referenced_entity_name
, T1.referenced_fullname
, T1.referenced_id
, T1.referenced_schema_name
, T1.referenced_type
, referenced_external_AntoraComponent = Null
, referenced_external_AntoraModule = Null
, referenced_is_external = 0
, T1.referencing_entity_name
, T1.referencing_fullname
, T1.referencing_id
, T1.referencing_schema_name
, T1.referencing_type
, referencing_external_AntoraComponent = Null
, referencing_external_AntoraModule = Null
, referencing_is_external = 0
, T1.InformationSource
, one = 1
From
reference.RepoObject_reference_persistence_target_as_source As T1
Where
--the naming of the objects matches: `aaa.bbb_ccc_tgt <- aaa.bbb`
T1.has_match_left_and_suffix_tgt = 1
Union All
Select
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, T1.referenced_entity_name
, T1.referenced_fullname
, T1.referenced_id
, T1.referenced_schema_name
, T1.referenced_type
, referenced_external_AntoraComponent = Null
, referenced_external_AntoraModule = Null
, referenced_is_external = 0
, T1.referencing_entity_name
, T1.referencing_fullname
, T1.referencing_id
, T1.referencing_schema_name
, T1.referencing_type
, referencing_external_AntoraComponent = Null
, referencing_external_AntoraModule = Null
, referencing_is_external = 0
, T1.InformationSource
, one = 1
From
reference.RepoObject_reference_persistence_target_as_source_explicit As T1
Union All
Select
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, T1.referenced_entity_name
, T1.referenced_fullname
, T1.referenced_id
, T1.referenced_schema_name
, T1.referenced_type
, T1.referenced_external_AntoraComponent
, T1.referenced_external_AntoraModule
, T1.referenced_is_external
, T1.referencing_entity_name
, T1.referencing_fullname
, T1.referencing_id
, T1.referencing_schema_name
, T1.referencing_type
, T1.referencing_external_AntoraComponent
, T1.referencing_external_AntoraModule
, T1.referencing_is_external
, T1.InformationSource
, one = 1
From
reference.RepoObject_reference_additional As T1