repo.check_IndexColumn_virtual_referenced_setpoint - V

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

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

Description

Examples

Entity Diagram

entity-repo.check_indexcolumn_virtual_referenced_setpoint

Columns

Table 1. Columns of repo.check_IndexColumn_virtual_referenced_setpoint - V
PK Column Name Data Type NULL? ID

int

NOT NULL

uniqueidentifier

NOT NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

nvarchar(261)

NULL

nvarchar(261)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-repo.check_indexcolumn_virtual_referenced_setpoint

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.check_indexcolumn_virtual_referenced_setpoint

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.check_indexcolumn_virtual_referenced_setpoint

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.check_indexcolumn_virtual_referenced_setpoint

Column Reference Diagram

entity_1_1_colref-repo.check_indexcolumn_virtual_referenced_setpoint

Indexes

idx_check_IndexColumn_virtual_referenced_setpoint__1

idx_check_IndexColumn_virtual_referenced_setpoint__2

idx_check_IndexColumn_virtual_referenced_setpoint__3

idx_check_IndexColumn_virtual_referenced_setpoint__4

idx_check_IndexColumn_virtual_referenced_setpoint__5

idx_check_IndexColumn_virtual_referenced_setpoint__6

idx_check_IndexColumn_virtual_referenced_setpoint__7

idx_check_IndexColumn_virtual_referenced_setpoint__8

Column Details

_

index_column_id

index_column_id

int

NOT NULL

index_guid

index_guid

uniqueidentifier

NOT NULL

referenced_index_guid

referenced_index_guid

uniqueidentifier

NULL

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NULL

referenced_RepoObjectColumn_guid

referenced_RepoObjectColumn_guid

uniqueidentifier

NULL

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NULL

referencing_RepoObjectColumn_guid

referencing_RepoObjectColumn_guid

uniqueidentifier

NULL

RepoObject_guid_s

RepoObject_guid_s

uniqueidentifier

NULL

RepoObject_guid_t

RepoObject_guid_t

uniqueidentifier

NULL

RepoObjectColumn_guid_t

RepoObjectColumn_guid_t

uniqueidentifier

NULL

SysObject_fullname_s

SysObject_fullname_s

nvarchar(261)

NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


SysObject_fullname_t

SysObject_fullname_t

nvarchar(261)

NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


SysObjectColumn_name_s

SysObjectColumn_name_s

nvarchar(128)

NULL

SysObjectColumn_name_t

SysObjectColumn_name_t

nvarchar(128)

NULL

sql_modules_definition

repo.check_IndexColumn_virtual_referenced_setpoint - V script
CREATE View repo.check_IndexColumn_virtual_referenced_setpoint
As
Select
    T1.index_guid
  , T1.index_column_id
  , T1.referencing_RepoObjectColumn_guid
  , T1.referenced_index_guid
  , T1.referenced_RepoObjectColumn_guid
  , SysObject_fullname_s    = ro_s.SysObject_fullname
  , SysObject_fullname_t    = ro_t.SysObject_fullname
  , SysObjectColumn_name_s  = roc_s.SysObjectColumn_name
  , SysObjectColumn_name_t  = roc_t.SysObjectColumn_name
  , T1.referenced_RepoObject_guid
  , RepoObject_guid_s       = roc_s.RepoObject_guid
  , T1.referencing_RepoObject_guid
  , RepoObject_guid_t       = roc_t.RepoObject_guid
  , RepoObjectColumn_guid_t = roc_t.RepoObjectColumn_guid
--    , [roc_s].[RepoObjectColumn_guid] AS [RepoObjectColumn_guid_s]
--, [roc_s].[RepoObjectColumn_name] AS [RepoObjectColumn_name_s]
--, [roc_t].[RepoObjectColumn_name] AS [RepoObjectColumn_name_t]
From
    repo.IndexColumn_virtual_referenced_setpoint As T1
    Left Outer Join
        repo.RepoObjectColumn                    As roc_t
            On
            T1.referencing_RepoObjectColumn_guid = roc_t.RepoObjectColumn_guid

    Left Outer Join
        repo.RepoObjectColumn                    As roc_s
            On
            T1.referenced_RepoObjectColumn_guid  = roc_s.RepoObjectColumn_guid

    Left Outer Join
        repo.RepoObject                          As ro_t
            On
            T1.referencing_RepoObject_guid       = ro_t.RepoObject_guid

    Left Outer Join
        repo.RepoObject                          As ro_s
            On
            T1.referenced_RepoObject_guid        = ro_s.RepoObject_guid
--WHERE  [T1].[index_guid] = '9731BB8B-CB50-EB11-84D5-A81E8446D5B0'