workflow.ProcedureDependency_gross - V
type: V ( view ), modify_date: 2021-08-17 20:24:45
RepoObject_guid: 48514649-189D-EB11-84F6-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_ProcedureDependency_gross__1
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObject_schema_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ProcedureDependency_gross__2
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObject_schema_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ProcedureDependency_gross__4
-
IndexSemanticGroup: no_group
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_ProcedureDependency_gross__5
-
IndexSemanticGroup: no_group
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_ProcedureDependency_gross__6
-
IndexSemanticGroup: no_group
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_Procedure_RepoObject_guid
referenced_Procedure_RepoObject_guid |
|
|
referenced_RepoObject_fullname
referenced_RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
referenced_RepoObject_fullname2
referenced_RepoObject_fullname2 |
|
|
(concat([RepoObject_schema_name],'.',[RepoObject_name]))
referenced_RepoObject_schema_name
referenced_RepoObject_schema_name |
|
|
referencing_Procedure_RepoObject_guid
referencing_Procedure_RepoObject_guid |
|
|
referencing_RepoObject_fullname
referencing_RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
referencing_RepoObject_fullname2
referencing_RepoObject_fullname2 |
|
|
(concat([RepoObject_schema_name],'.',[RepoObject_name]))
sql_modules_definition
workflow.ProcedureDependency_gross - V script
CREATE View workflow.ProcedureDependency_gross
As
Select
pd.id
, pd.referenced_Procedure_RepoObject_guid
, pd.referencing_Procedure_RepoObject_guid
, pd.is_active
, pd.is_PersistenceDependency
, pd.Description
, referenced_RepoObject_fullname = ro_1.RepoObject_fullname
, referenced_RepoObject_fullname2 = ro_1.RepoObject_fullname2
, referenced_RepoObject_schema_name = ro_1.RepoObject_schema_name
, referencing_RepoObject_fullname = ro_2.RepoObject_fullname
, referencing_RepoObject_fullname2 = ro_2.RepoObject_fullname2
, referencing_RepoObject_schema_name = ro_2.RepoObject_schema_name
From
workflow.ProcedureDependency As pd
Inner Join
repo.RepoObject As ro_1
On
pd.referenced_Procedure_RepoObject_guid = ro_1.RepoObject_guid
Inner Join
repo.RepoObject As ro_2
On
pd.referencing_Procedure_RepoObject_guid = ro_2.RepoObject_guid