repo.RepoObject_persistence_column - V
type: V ( view ), modify_date: 2022-01-05 18:06:33
RepoObject_guid: 0490291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObject_persistence_column
-
IndexSemanticGroup: no_group
-
[column-target_RepoObject_guid]; uniqueidentifier
-
[column-RepoObjectColumn_guid_s]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObject_persistence_column__2
-
IndexSemanticGroup: no_group
-
[column-SysObject_schema_name_s]; nvarchar(128)
-
[column-SysObject_name_s]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_persistence_column__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name_t]; nvarchar(128)
-
[column-RepoObject_name_t]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_persistence_column__4
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid_s]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_persistence_column__5
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid_s]; uniqueidentifier
-
[column-SysObjectColumn_name_s]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_persistence_column__6
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_name_t]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_persistence_column__7
-
IndexSemanticGroup: no_group
-
[column-target_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
is_persistence_check_for_empty_source
is_persistence_check_for_empty_source |
|
|
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