reference.RepoObject_reference_additional_internal - V
type: V ( view ), modify_date: 2022-01-05 18:06:34
RepoObject_guid: 9EB0B5F7-B004-EC11-8514-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObject_reference_additional_internal__1
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_reference_additional_internal__2
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_fullname
referenced_fullname |
|
|
Description
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
Referenced Columns
referencing_fullname
referencing_fullname |
|
|
Description
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
Referenced Columns
sql_modules_definition
reference.RepoObject_reference_additional_internal - V script
CREATE View reference.RepoObject_reference_additional_internal
As
Select
--distinct, because the source also contains columns
Distinct
T1.referenced_RepoObject_guid
, T1.referencing_RepoObject_guid
, referenced_entity_name = T1.referenced_Object
, T1.referenced_fullname
, T1.referenced_id
--, referenced_node_id
, referenced_schema_name = T1.referenced_Schema
, T1.referenced_type
, referencing_entity_name = T1.referencing_Object
, T1.referencing_fullname
, T1.referencing_id
--, referencing_node_id
, referencing_schema_name = T1.referencing_Schema
, T1.referencing_type
, InformationSource = 'reference.additional_Reference'
From
reference.additional_Reference_guid As T1
Where
T1.referenced_is_external = 0
And T1.referencing_is_external = 0
And Not T1.referenced_RepoObject_guid Is Null
And Not T1.referencing_RepoObject_guid Is Null