reference.SysObjectColumn_QueryPlanExpression - V

type: V ( view ), modify_date: 2022-01-05 18:06:34

RepoObject_guid: 6D90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.sysobjectcolumn_queryplanexpression

Columns

Table 1. Columns of reference.SysObjectColumn_QueryPlanExpression - V
PK Column Name Data Type NULL? ID

uniqueidentifier

NULL

int

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.sysobjectcolumn_queryplanexpression

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.sysobjectcolumn_queryplanexpression

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.sysobjectcolumn_queryplanexpression

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.sysobjectcolumn_queryplanexpression

Column Reference Diagram

entity_1_1_colref-reference.sysobjectcolumn_queryplanexpression

Column Details

_

RepoObject_guid

RepoObject_guid

uniqueidentifier

NULL

SysObjectColumn_column_id

SysObjectColumn_column_id

int

NULL

SysObjectColumn_name

SysObjectColumn_name

nvarchar(128)

NULL

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