reference.RepoObjectColumn_reference_additional_internal - V
type: V ( view ), modify_date: 2022-01-05 18:06:34
RepoObject_guid: 9FB0B5F7-B004-EC11-8514-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObjectColumn_reference_additional_internal__1
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_reference_additional_internal__2
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_reference_additional_internal__3
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_reference_additional_internal__4
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
is_referencing_object_equal_referenced_object
is_referencing_object_equal_referenced_object |
|
|
referenced_RepoObjectColumn_guid
referenced_RepoObjectColumn_guid |
|
|
referencing_RepoObjectColumn_guid
referencing_RepoObjectColumn_guid |
|
|
sql_modules_definition
reference.RepoObjectColumn_reference_additional_internal - V script
CREATE View reference.RepoObjectColumn_reference_additional_internal
As
--
Select
T1.referencing_id
--, referencing_minor_id = roc.SysObjectColumn_column_id
--, referencing_node_id = roc.node_id
, T1.referenced_id
--, referenced_minor_id = roc2.SysObjectColumn_column_id
--, referenced_node_id = roc2.node_id
, T1.referencing_RepoObject_guid
, T1.referencing_RepoObjectColumn_guid
, T1.referenced_RepoObject_guid
, T1.referenced_RepoObjectColumn_guid
, T1.referencing_type
, referencing_schema_name = T1.referencing_Schema
, referencing_entity_name = T1.referencing_Object
, referencing_column_name = T1.referencing_Column
, referenced_schema_name = T1.referenced_Schema
, referenced_entity_name = T1.referenced_Object
, referenced_column_name = T1.referenced_Column
, T1.referenced_type
, InformationSource = 'reference.additional_Reference'
, is_referencing_object_equal_referenced_object = Cast(Case
When T1.referenced_RepoObject_guid = T1.referencing_RepoObject_guid
Then
1
Else
0
End As Bit)
--Flag, if the [referenced_RepoObject_guid] is a referenced object in [repo].[RepoObject_reference__union]
, is_referenced_object =
(
Select
Top 1
Cast(1 As Bit)
From
reference.RepoObject_reference_T As ro_r
Where
ro_r.referencing_RepoObject_guid = ro_r.referencing_RepoObject_guid
And ro_r.referenced_RepoObject_guid = ro_r.referenced_RepoObject_guid
)
--, ros.is_hidden
, is_computed = Cast(Null As Bit)
, definition = Cast(Null As NVarchar(Max))
From
reference.additional_Reference_guid As T1
Where
T1.referenced_is_external = 0
And T1.referencing_is_external = 0
And Not T1.referenced_RepoObjectColumn_guid Is Null
And Not T1.referencing_RepoObjectColumn_guid Is Null