reference.RepoObjectColumn_reference_SqlExpressionDependencies - V
type: V ( view ), modify_date: 2022-01-05 18:06:35
RepoObject_guid: 6490291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
4 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObjectColumn_reference_SqlExpressionDependencies
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 1, 1, 0
idx_RepoObjectColumn_reference_SqlExpressionDependencies__2
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_reference_SqlExpressionDependencies__3
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_reference_SqlExpressionDependencies__4
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_reference_SqlExpressionDependencies__5
-
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_SqlExpressionDependencies - V script
CREATE View reference.RepoObjectColumn_reference_SqlExpressionDependencies
As
--
Select
sed.referencing_id
, sed.referencing_minor_id
, referencing_node_id = Cast(sed.referencing_id As BigInt) * 10000 + sed.referencing_minor_id
, sed.referenced_id
, sed.referenced_minor_id
, referenced_node_id = Cast(sed.referenced_id As BigInt) * 10000 + sed.referenced_minor_id
, sed.referencing_RepoObject_guid
, sed.referencing_RepoObjectColumn_guid
, sed.referenced_RepoObject_guid
, sed.referenced_RepoObjectColumn_guid
, sed.referencing_type
, sed.referencing_schema_name
, sed.referencing_entity_name
, sed.referencing_column_name
, sed.referenced_schema_name
, sed.referenced_entity_name
, sed.referenced_column_name
, sed.referenced_type
, InformationSource = 'sys.sql_expression_dependencies'
, sed.is_computed
, sed.definition
, is_referencing_object_equal_referenced_object =
--
Cast(Case
When sed.referencing_RepoObject_guid = sed.referenced_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 = sed.referencing_RepoObject_guid
And ro_r.referenced_RepoObject_guid = sed.referenced_RepoObject_guid
)
--, [sed].[referenced_server_name]
--, [sed].[referenced_database_name]
--, [sed].[referenced_class]
--, [sed].[referencing_class]
--, [sed].[referencing_class_desc]
--, [sed].[referenced_class_desc]
--, [sed].[referencing_type_desciption]
--, [sed].[referenced_type_desciption]
--, [sed].[is_schema_bound_reference]
--, [sed].[is_caller_dependent]
--, [sed].[is_ambiguous]
From
repo_sys.sql_expression_dependencies As sed
Where
--column level
sed.referencing_minor_id <> 0
And sed.referenced_minor_id <> 0
--exclude virtual objects (like expressions used in procedures)
--or objects without extended properties (like triggers)
--currently:
--[RepoObject_guid] = [sed].[referencing_RepoObject_guid]
--and [sed].[referencing_RepoObject_guid] = SysObject_RepoObject_guid
--these are RepoObject_guid storred in extended properties
And Not sed.referencing_RepoObject_guid Is Null
And Not sed.referenced_RepoObject_guid Is Null