repo.RepoObject_persistence_column - V

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

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

Description

Examples

Entity Diagram

entity-repo.repoobject_persistence_column

Columns

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

1

uniqueidentifier

NOT NULL

2

uniqueidentifier

NULL

bit

NOT NULL

bit

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NOT NULL

nvarchar(128)

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

char(2)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_persistence_column

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_persistence_column

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_persistence_column

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_persistence_column

Column Reference Diagram

entity_1_1_colref-repo.repoobject_persistence_column

Indexes

PK_RepoObject_persistence_column

idx_RepoObject_persistence_column__2

idx_RepoObject_persistence_column__3

idx_RepoObject_persistence_column__4

idx_RepoObject_persistence_column__5

idx_RepoObject_persistence_column__6

idx_RepoObject_persistence_column__7

Column Details

_

target_RepoObject_guid

1

target_RepoObject_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_guid_s

2

RepoObjectColumn_guid_s

uniqueidentifier

NULL

has_history

has_history

bit

NOT NULL

has_history_columns

has_history_columns

bit

NOT NULL

history_schema_name

history_schema_name

nvarchar(128)

NULL

history_table_name

history_table_name

nvarchar(128)

NULL

is_persistence

is_persistence

bit

NULL

is_persistence_check_for_empty_source

is_persistence_check_for_empty_source

bit

NOT NULL

is_persistence_delete_changed

is_persistence_delete_changed

bit

NOT NULL

is_persistence_delete_missing

is_persistence_delete_missing

bit

NOT NULL

is_persistence_insert

is_persistence_insert

bit

NOT NULL

is_persistence_truncate

is_persistence_truncate

bit

NOT NULL

is_persistence_update_changed

is_persistence_update_changed

bit

NOT NULL

is_repo_managed_t

is_repo_managed_t

bit

NULL

Referenced Columns

RepoObject_name_t

RepoObject_name_t

nvarchar(128)

NOT NULL

Referenced Columns

RepoObject_schema_name_t

RepoObject_schema_name_t

nvarchar(128)

NOT NULL

RepoObject_type_t

RepoObject_type_t

char(2)

NOT NULL

Referenced Columns

RepoObjectColumn_name_t

RepoObjectColumn_name_t

nvarchar(128)

NULL

source_RepoObject_guid

source_RepoObject_guid

uniqueidentifier

NULL

SysObject_name_s

SysObject_name_s

nvarchar(128)

NULL

Referenced Columns

SysObject_schema_name_s

SysObject_schema_name_s

nvarchar(128)

NULL

SysObject_type_s

SysObject_type_s

char(2)

NULL

Referenced Columns

SysObjectColumn_name_s

SysObjectColumn_name_s

nvarchar(128)

NULL

sql_modules_definition

repo.RepoObject_persistence_column - V script
/*
wof├╝r soll diese Sicht verwendet werden?
noch nicht fertig
*/
CREATE View repo.RepoObject_persistence_column
As
--
Select
    rop.target_RepoObject_guid
  , rop.source_RepoObject_guid
  , RepoObjectColumn_guid_s  = roc_s.RepoObjectColumn_guid
  , SysObject_schema_name_s  = ro_s.SysObject_schema_name
  , SysObject_name_s         = ro_s.SysObject_name
  , SysObjectColumn_name_s   = roc_s.SysObjectColumn_name
  , SysObject_type_s         = ro_s.SysObject_type
  , RepoObject_schema_name_t = ro_t.RepoObject_schema_name
  , RepoObject_name_t        = ro_t.RepoObject_name
  , RepoObjectColumn_name_t  = roc_t.RepoObjectColumn_name
  , RepoObject_type_t        = ro_t.RepoObject_type
  , is_repo_managed_t        = ro_t.is_repo_managed
  , rop.is_persistence_truncate
  , rop.is_persistence_delete_missing
  , rop.is_persistence_delete_changed
  , rop.is_persistence_update_changed
  , rop.is_persistence_insert
  , has_history              = rop.has_history
  , has_history_columns      = rop.has_history_columns
  , rop.is_persistence_check_for_empty_source
  , rop.history_schema_name
  , rop.history_table_name
  , rop.is_persistence
--       --, [roc_s].[RepoObject_guid]
--       --, [roc_s].[RepoObjectColumn_name]
--       --, [roc_s].[SysObjectColumn_column_id]
--       --, [roc_s].[is_SysObjectColumn_missing]
--       --, [roc_s].[Source_PersistenceColumn_guid]
--     , [roc_s].[Target_PersistenceColumn_guid] AS [Target_PersistenceColumn_guid_s]
--     , [roc_s].[is_force_persistence] AS          [is_force_persistence_s]
--     , [roc_s].[is_force_persistence_name] AS     [is_force_persistence_name_s]
--       --, [roc_s].[persistence_source_RepoObjectColumn_guid]
--       --, [roc_s].[Referencing_Count]
--       --, [roc_s].[has_different_sys_names]
--       --, [roc_s].[is_RepoObjectColumn_name_uniqueidentifier]
--       --, [roc_s].[is_SysObjectColumn_name_uniqueidentifier]
--       --, [roc_t].[RepoObjectColumn_guid]
--       --, [roc_t].[RepoObject_guid]
--       --, [roc_t].[SysObjectColumn_name]
--       --, [roc_t].[SysObjectColumn_column_id]
--       --, [roc_t].[is_SysObjectColumn_missing]
--       --, [roc_t].[Target_PersistenceColumn_guid]
--     , [roc_t].[is_force_persistence] AS          [is_force_persistence_t]
--     , [roc_t].[is_force_persistence_name] AS     [is_force_persistence_name_t]
----, [roc_t].[persistence_source_RepoObjectColumn_guid]
----, [roc_t].[Referencing_Count]
----, [roc_t].[has_different_sys_names]
----, [roc_t].[is_RepoObjectColumn_name_uniqueidentifier]
----, [roc_t].[is_SysObjectColumn_name_uniqueidentifier]
From
    repo.RepoObject_persistence As rop
    Inner Join
        repo.RepoObject         As ro_t
            On
            rop.target_RepoObject_guid                         = ro_t.RepoObject_guid

    Left Outer Join
        repo.RepoObject         As ro_s
            On
            rop.source_RepoObject_guid                         = ro_s.RepoObject_guid

    Left Outer Join
        repo.RepoObjectColumn   As roc_s
            On
            rop.source_RepoObject_guid                         = roc_s.RepoObject_guid

    Left Join
        repo.RepoObjectColumn   As roc_t
            On
            roc_t.RepoObject_guid                              = rop.target_RepoObject_guid
            And roc_t.persistence_source_RepoObjectColumn_guid = roc_s.RepoObjectColumn_guid