reference.SysObjectColumn_QueryPlanExpression - V
type: V ( view ), modify_date: 2022-01-05 18:06:34
RepoObject_guid: 6D90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
sql_modules_definition
reference.SysObjectColumn_QueryPlanExpression - V script
CREATE View reference.SysObjectColumn_QueryPlanExpression
As
--
Select
RepoObject_guid = referencing_RepoObject_guid
, SysObjectColumn_column_id = Try_Cast(Right(referencing_column_name, 4) As Int)
, SysObjectColumn_name = referencing_column_name
From
reference.RepoObjectColumn_reference_QueryPlan
Where
is_target_column_name_expression = 1
Union
Select
referenced_RepoObject_guid
, SysObjectColumn_column_id = Try_Cast(Right(referenced_column_name, 4) As Int)
, referenced_column_name
From
reference.RepoObjectColumn_reference_QueryPlan
Where
is_source_column_name_expression = 1
And Not referenced_RepoObject_guid Is Null