repo.RepoObject_persistence_ForUpdate - V

type: V ( view ), modify_date: 2022-09-05 16:37:45

RepoObject_guid: 88813D1C-6662-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject_persistence_forupdate

Columns

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

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(128)

NULL

bit

NOT NULL

bit

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

nvarchar(128)

NOT NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_persistence_forupdate

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_persistence_forupdate

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_persistence_forupdate

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_persistence_forupdate

Column Reference Diagram

entity_1_1_colref-repo.repoobject_persistence_forupdate

Indexes

idx_RepoObject_persistence_ForUpdate__1

idx_RepoObject_persistence_ForUpdate__2

Column Details

_

ColumnListIgnore

ColumnListIgnore

nvarchar(4000)

NULL

ColumnListNoCompareButUpdate

ColumnListNoCompareButUpdate

nvarchar(4000)

NULL

ColumnListNoCompareNoUpdate

ColumnListNoCompareNoUpdate

nvarchar(4000)

NULL

ColumnListNoInsert

ColumnListNoInsert

nvarchar(4000)

NULL

default_source_RepoObject_name

default_source_RepoObject_name

nvarchar(128)

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_check_duplicate_per_pk

is_persistence_check_duplicate_per_pk

bit

NOT 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_persist_source

is_persistence_persist_source

bit

NOT NULL

is_persistence_truncate

is_persistence_truncate

bit

NOT NULL

is_persistence_update_changed

is_persistence_update_changed

bit

NOT NULL

postscript

postscript

nvarchar(max)

NULL

prescript

prescript

nvarchar(max)

NULL

source_RepoObject_guid

source_RepoObject_guid

uniqueidentifier

NULL

source_RepoObject_name

source_RepoObject_name

nvarchar(128)

NULL

target_name

target_name

nvarchar(128)

NOT NULL

Referenced Columns

target_RepoObject_fullname

target_RepoObject_fullname

nvarchar(261)

NOT NULL

Description

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


target_RepoObject_fullname2

target_RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

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


target_RepoObject_guid

target_RepoObject_guid

uniqueidentifier

NOT NULL

target_schema

target_schema

nvarchar(128)

NOT NULL

sql_modules_definition

repo.RepoObject_persistence_ForUpdate - V script
/*
Added some lookup columns [repo].[RepoObject_persistence]
to simplify data entry in the frontend
*/
CREATE View [repo].[RepoObject_persistence_ForUpdate]
As
Select
    ro_p.target_RepoObject_guid
  , target_RepoObject_fullname     = ro.RepoObject_fullname
  , target_RepoObject_fullname2    = ro.RepoObject_fullname2
  , target_name                    = ro.RepoObject_name
  , target_schema                  = ro.RepoObject_schema_name
  , ro_p.has_history
  , ro_p.has_history_columns
  , ro_p.history_schema_name
  , ro_p.history_table_name
  , ro_p.is_persistence_check_duplicate_per_pk
  , ro_p.is_persistence_check_for_empty_source
  , ro_p.is_persistence_delete_changed
  , ro_p.is_persistence_delete_missing
  , ro_p.is_persistence_insert
  , ro_p.is_persistence_truncate
  , ro_p.is_persistence_update_changed
  , ro_p.is_persistence_persist_source
  , ro_p.ColumnListIgnore
  , ro_p.ColumnListNoCompareButUpdate
  , ro_p.ColumnListNoCompareNoUpdate
  , ro_p.ColumnListNoInsert
  , ro_p.source_RepoObject_guid
  , ro_p.prescript
  , ro_p.postscript
  --, ro_p.is_persistence
  --, ro_p.temporal_type
  , ro_p.source_RepoObject_name
  , default_source_RepoObject_name = Iif(Right(ro.RepoObject_name, 2) = '_T'
                                         , Left(ro.RepoObject_name, Len ( ro.RepoObject_name ) - 2)
                                         , Null)
From
    repo.RepoObject_persistence As ro_p
    Inner Join
        repo.RepoObject         As ro
            On
            ro.RepoObject_guid = ro_p.target_RepoObject_guid