workflow.ProcedureDependency_input_PersistenceDependency - V
type: V ( view ), modify_date: 2021-08-17 20:25:10
RepoObject_guid: 99B707FE-71F7-EB11-850C-A81E8446D5B0
is_repo_managed: 1
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_ProcedureDependency_input_PersistenceDependency__1
-
IndexSemanticGroup: no_group
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
-
is disabled
idx_ProcedureDependency_input_PersistenceDependency__2
-
IndexSemanticGroup: no_group
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
-
is disabled
idx_ProcedureDependency_input_PersistenceDependency__3
-
IndexSemanticGroup: no_group
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_Procedure_RepoObject_guid
referenced_Procedure_RepoObject_guid |
|
|
Referenced Columns
sql_modules_definition
workflow.ProcedureDependency_input_PersistenceDependency - V script
CREATE View workflow.ProcedureDependency_input_PersistenceDependency
As
Select
referenced_Procedure_RepoObject_guid
, referencing_Procedure_RepoObject_guid
, is_PersistenceDependency
--, [is_active]
--, [Description]
--, [id]
From
workflow.ProcedureDependency
Where
is_PersistenceDependency = 1