workflow.ProcedureDependency_PersistenceDependency_tgt - V
type: V ( view ), modify_date: 2021-11-17 23:12:07
RepoObject_guid: FE1F04C7-F347-EC11-8530-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
Persistence, History Table
-
persistence source: workflow.ProcedureDependency_PersistenceDependency_src - V
-
is_persistence: 1
-
is_persistence_check_duplicate_per_pk: 0
-
is_persistence_check_for_empty_source: 0
-
is_persistence_delete_changed: 0
-
is_persistence_delete_missing: 1
-
is_persistence_insert: 1
-
is_persistence_truncate: 0
-
is_persistence_update_changed: 1
-
has_history: 0
-
has_history_columns: 0
Indexes
PK_ProcedureDependency_PersistenceDependency_tgt
-
IndexSemanticGroup: referenced_Procedure_RepoObject_guid,referencing_Procedure_RepoObject_guid
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
idx_ProcedureDependency_PersistenceDependency_tgt__2
-
IndexSemanticGroup: no_group
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_ProcedureDependency_PersistenceDependency_tgt__3
-
IndexSemanticGroup: no_group
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
workflow.ProcedureDependency_PersistenceDependency_tgt - V script
create View [workflow].[ProcedureDependency_PersistenceDependency_tgt]
As
Select
referenced_Procedure_RepoObject_guid
, referencing_Procedure_RepoObject_guid
, is_PersistenceDependency
--, [is_active]
--, [Description]
--, [id]
From
workflow.ProcedureDependency
Where
is_PersistenceDependency = 1