workflow.ProcedureDependency_input_PersistenceDependency_S - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: 9AB707FE-71F7-EB11-850C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.proceduredependency_input_persistencedependency_s

Columns

Table 1. Columns of workflow.ProcedureDependency_input_PersistenceDependency_S - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NULL

2

uniqueidentifier

NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.proceduredependency_input_persistencedependency_s

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.proceduredependency_input_persistencedependency_s

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.proceduredependency_input_persistencedependency_s

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.proceduredependency_input_persistencedependency_s

Column Reference Diagram

entity_1_1_colref-workflow.proceduredependency_input_persistencedependency_s

Indexes

PK_ProcedureDependency_input_PersistenceDependency_S

idx_ProcedureDependency_input_PersistenceDependency_S__2

idx_ProcedureDependency_input_PersistenceDependency_S__3

Column Details

_

referenced_Procedure_RepoObject_guid

1

referenced_Procedure_RepoObject_guid

uniqueidentifier

NULL

referencing_Procedure_RepoObject_guid

2

referencing_Procedure_RepoObject_guid

uniqueidentifier

NULL

is_PersistenceDependency

is_PersistenceDependency

int

NOT NULL

sql_modules_definition

workflow.ProcedureDependency_input_PersistenceDependency_S - V script
CREATE View workflow.ProcedureDependency_input_PersistenceDependency_S
As
Select
    referenced_Procedure_RepoObject_guid  = T1.referenced_usp_persistence_RepoObject_guid
  , referencing_Procedure_RepoObject_guid = T1.referencing_usp_persistence_RepoObject_guid
  , is_PersistenceDependency              = 1
--, T1.referenced_RepoObject_guid
--, T1.referencing_RepoObject_guid
From
    reference.Persistence As T1
Where
    ( Not ( T1.referenced_usp_persistence_RepoObject_guid Is Null ))
    And ( Not ( T1.referencing_usp_persistence_RepoObject_guid Is Null ))