reference.RepoObject_reference_virtual - V

type: V ( view ), modify_date: 2021-08-17 19:16:08

RepoObject_guid: 4677342A-21A5-EB11-84FA-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_reference_virtual

Columns

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

varchar(34)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(261)

NOT NULL

int

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NULL

nvarchar(128)

NOT NULL

nvarchar(261)

NOT NULL

int

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

varchar(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_reference_virtual

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_reference_virtual

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_reference_virtual

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_reference_virtual

Column Reference Diagram

entity_1_1_colref-reference.repoobject_reference_virtual

Indexes

idx_RepoObject_reference_virtual__1

idx_RepoObject_reference_virtual__2

idx_RepoObject_reference_virtual__3

idx_RepoObject_reference_virtual__4

idx_RepoObject_reference_virtual__5

Column Details

_

InformationSource

InformationSource

varchar(34)

NOT NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NOT NULL

Referenced Columns

referenced_fullname

referenced_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


referenced_id

referenced_id

int

NULL

Referenced Columns

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NOT NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NOT NULL

referenced_type

referenced_type

char(2)

NULL

Referenced Columns

referencing_entity_name

referencing_entity_name

nvarchar(128)

NOT NULL

Referenced Columns

referencing_fullname

referencing_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


referencing_id

referencing_id

int

NULL

Referenced Columns

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NOT NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NOT NULL

referencing_type

referencing_type

varchar(2)

NULL

sql_modules_definition

reference.RepoObject_reference_virtual - V script
CREATE View reference.RepoObject_reference_virtual
As
--
Select
    --
    referenced_RepoObject_guid  = rov.Source_RepoObject_guid
  , referencing_RepoObject_guid = rov.RepoObject_guid
  , referenced_entity_name      = ro_s.SysObject_name
  , referenced_fullname         = ro_s.RepoObject_fullname
  , referenced_id               = ro_s.SysObject_id
  --, referenced_node_id          = ro_s.node_id
  , referenced_schema_name      = ro_s.SysObject_schema_name
  , referenced_type             = ro_s.SysObject_type
  , referencing_entity_name     = ro_t.SysObject_name
  , referencing_fullname        = ro_t.RepoObject_fullname
  , referencing_id              = ro_t.SysObject_id
  --, referencing_node_id         = ro_t.node_id
  , referencing_schema_name     = ro_t.SysObject_schema_name
  , referencing_type            = Coalesce ( ro_t.SysObject_type, ro_t.RepoObject_type, 'U' )
  , InformationSource           = 'reference.RepoObjectSource_virtual'
From
    reference.RepoObjectSource_virtual As rov
    Inner Join
        repo.RepoObject                As ro_t
            On
            ro_t.RepoObject_guid = rov.RepoObject_guid

    Inner Join
        repo.RepoObject                As ro_s
            On
            ro_s.RepoObject_guid = rov.Source_RepoObject_guid