repo.RepoObject_persistence_ForUpdate - V
type: V ( view ), modify_date: 2022-09-05 16:37:45
RepoObject_guid: 88813D1C-6662-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObject_persistence_ForUpdate__1
-
IndexSemanticGroup: no_group
-
[column-target_schema]; nvarchar(128)
-
[column-target_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_persistence_ForUpdate__2
-
IndexSemanticGroup: no_group
-
[column-target_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
default_source_RepoObject_name
default_source_RepoObject_name |
|
|
is_persistence_check_duplicate_per_pk
is_persistence_check_duplicate_per_pk |
|
|
is_persistence_check_for_empty_source
is_persistence_check_for_empty_source |
|
|
source_RepoObject_guid
source_RepoObject_guid |
|
|
source_RepoObject_name
source_RepoObject_name |
|
|
target_RepoObject_fullname
target_RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
target_RepoObject_fullname2
target_RepoObject_fullname2 |
|
|
(concat([RepoObject_schema_name],'.',[RepoObject_name]))
target_RepoObject_guid
target_RepoObject_guid |
|
|
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