repo_sys.ColumnReference - V

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

RepoObject_guid: 5C90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo_sys.columnreference

Columns

Table 1. Columns of repo_sys.ColumnReference - V
PK Column Name Data Type NULL? ID

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

tinyint

NULL

nvarchar(60)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

int

NULL

int

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

int

NULL

nvarchar(517)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo_sys.columnreference

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo_sys.columnreference

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo_sys.columnreference

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo_sys.columnreference

Column Reference Diagram

entity_1_1_colref-repo_sys.columnreference

Column Details

_

is_all_columns_found

is_all_columns_found

bit

NOT NULL

is_ambiguous

is_ambiguous

bit

NOT NULL

is_caller_dependent

is_caller_dependent

bit

NOT NULL

is_incomplete

is_incomplete

bit

NOT NULL

is_insert_all

is_insert_all

bit

NOT NULL

is_select_all

is_select_all

bit

NOT NULL

is_selected

is_selected

bit

NOT NULL

is_updated

is_updated

bit

NOT NULL

referenced_class

referenced_class

tinyint

NULL

referenced_class_desc

referenced_class_desc

nvarchar(60)

NULL

referenced_database_name

referenced_database_name

nvarchar(128)

NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NULL

referenced_id

referenced_id

int

NULL

referenced_minor_id

referenced_minor_id

int

NULL

referenced_minor_name

referenced_minor_name

nvarchar(128)

NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL

referenced_server_name

referenced_server_name

nvarchar(128)

NULL

referencing_minor_id

referencing_minor_id

int

NULL

SysObject_full_name

SysObject_full_name

nvarchar(517)

NOT NULL

sql_modules_definition

repo_sys.ColumnReference - V script
CREATE View repo_sys.ColumnReference
As
--
--muss / kann noch angereichert werden
Select
    SysObject_full_name = so.SysObject_fullname
  , sdsre.referencing_minor_id
  , sdsre.referenced_server_name
  , sdsre.referenced_database_name
  , sdsre.referenced_schema_name
  , sdsre.referenced_entity_name
  , sdsre.referenced_minor_name
  , sdsre.referenced_id
  , sdsre.referenced_minor_id
  , sdsre.referenced_class
  , sdsre.referenced_class_desc
  , sdsre.is_caller_dependent
  , sdsre.is_ambiguous
  , sdsre.is_selected
  , sdsre.is_updated
  , sdsre.is_select_all
  , sdsre.is_all_columns_found
  , sdsre.is_insert_all
  , sdsre.is_incomplete
From
    repo_sys.SysObject                                                                 As so
    Cross Apply sys_dwh.dm_sql_referenced_entities ( so.SysObject_fullname, 'OBJECT' ) As sdsre
Where
    so.type In
    ( 'U', 'V' )