reference.RepoObjectColumn_reference_SqlExpressionDependencies - V

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

RepoObject_guid: 6490291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobjectcolumn_reference_sqlexpressiondependencies

Columns

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

1

int

NOT NULL

2

int

NOT NULL

3

int

NULL

4

int

NOT NULL

nvarchar(max)

NULL

varchar(31)

NOT NULL

bit

NULL

bit

NULL

bit

NULL

sysname

NULL

nvarchar(128)

NULL

bigint

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

char(2)

NULL

sysname

NULL

nvarchar(128)

NULL

bigint

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

char(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobjectcolumn_reference_sqlexpressiondependencies

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectcolumn_reference_sqlexpressiondependencies

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectcolumn_reference_sqlexpressiondependencies

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectcolumn_reference_sqlexpressiondependencies

Column Reference Diagram

entity_1_1_colref-reference.repoobjectcolumn_reference_sqlexpressiondependencies

Indexes

PK_RepoObjectColumn_reference_SqlExpressionDependencies

idx_RepoObjectColumn_reference_SqlExpressionDependencies__2

idx_RepoObjectColumn_reference_SqlExpressionDependencies__3

idx_RepoObjectColumn_reference_SqlExpressionDependencies__4

idx_RepoObjectColumn_reference_SqlExpressionDependencies__5

Column Details

_

referencing_id

1

referencing_id

int

NOT NULL

referencing_minor_id

2

referencing_minor_id

int

NOT NULL

referenced_id

3

referenced_id

int

NULL

referenced_minor_id

4

referenced_minor_id

int

NOT NULL

definition

definition

nvarchar(max)

NULL

InformationSource

InformationSource

varchar(31)

NOT NULL

is_computed

is_computed

bit

NULL

is_referenced_object

is_referenced_object

bit

NULL

is_referencing_object_equal_referenced_object

is_referencing_object_equal_referenced_object

bit

NULL

referenced_column_name

referenced_column_name

sysname

NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NULL

referenced_node_id

referenced_node_id

bigint

NULL

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NULL

referenced_RepoObjectColumn_guid

referenced_RepoObjectColumn_guid

uniqueidentifier

NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL

referenced_type

referenced_type

char(2)

NULL

referencing_column_name

referencing_column_name

sysname

NULL

referencing_entity_name

referencing_entity_name

nvarchar(128)

NULL

referencing_node_id

referencing_node_id

bigint

NULL

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NULL

referencing_RepoObjectColumn_guid

referencing_RepoObjectColumn_guid

uniqueidentifier

NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NULL

referencing_type

referencing_type

char(2)

NULL

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