workflow.Workflow_ProcedureDependency_T_TaskName - V

type: V ( view ), modify_date: 2021-08-17 20:29:29

RepoObject_guid: A3BCD983-91FA-EB11-850E-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.workflow_proceduredependency_t_taskname

Columns

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

uniqueidentifier

NOT NULL

nvarchar(257)

NOT NULL

nvarchar(4000)

NULL

uniqueidentifier

NOT NULL

nvarchar(257)

NOT NULL

nvarchar(4000)

NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.workflow_proceduredependency_t_taskname

References

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.workflow_proceduredependency_t_taskname

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.workflow_proceduredependency_t_taskname

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.workflow_proceduredependency_t_taskname

Column Reference Diagram

entity_1_1_colref-workflow.workflow_proceduredependency_t_taskname

Indexes

idx_Workflow_ProcedureDependency_T_TaskName__1

idx_Workflow_ProcedureDependency_T_TaskName__2

idx_Workflow_ProcedureDependency_T_TaskName__3

idx_Workflow_ProcedureDependency_T_TaskName__4

idx_Workflow_ProcedureDependency_T_TaskName__5

Column Details

_

referenced_Procedure_RepoObject_guid

referenced_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

referenced_RepoObject_fullname2

referenced_RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


referenced_TaskName

referenced_TaskName

nvarchar(4000)

NULL

referencing_Procedure_RepoObject_guid

referencing_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

referencing_RepoObject_fullname2

referencing_RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


referencing_TaskName

referencing_TaskName

nvarchar(4000)

NULL

Workflow_id

Workflow_id

int

NOT NULL

sql_modules_definition

workflow.Workflow_ProcedureDependency_T_TaskName - V script
CREATE View workflow.Workflow_ProcedureDependency_T_TaskName
As
Select
    T1.Workflow_id
  , T1.referenced_Procedure_RepoObject_guid
  , T1.referencing_Procedure_RepoObject_guid
  , referenced_RepoObject_fullname2  = ro1.RepoObject_fullname2
  , referencing_RepoObject_fullname2 = ro2.RepoObject_fullname2
  , referenced_TaskName              = Replace ( ro1.RepoObject_fullname2, '.', '_' )
  , referencing_TaskName             = Replace ( ro2.RepoObject_fullname2, '.', '_' )
From
    workflow.Workflow_ProcedureDependency_T_active As T1
    Inner Join
        repo.RepoObject                            As ro1
            On
            T1.referenced_Procedure_RepoObject_guid  = ro1.RepoObject_guid

    Inner Join
        repo.RepoObject                            As ro2
            On
            T1.referencing_Procedure_RepoObject_guid = ro2.RepoObject_guid
Where
    T1.is_redundant = 0