reference.RepoObjectColumn_ReferencedReferencing - V
type: V ( view ), modify_date: 2021-10-01 22:43:29
RepoObject_guid: 3E4679B8-147C-EB11-84E6-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObjectColumn_ReferencedReferencing__1
-
IndexSemanticGroup: no_group
-
[column-Referenced_guid]; uniqueidentifier
-
[column-Referencing_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_external_AntoraComponent
referenced_external_AntoraComponent |
|
|
referenced_external_AntoraModule
referenced_external_AntoraModule |
|
|
Referenced_fullname
Referenced_fullname |
|
|
(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],']'))
Referenced_fullname2
Referenced_fullname2 |
|
|
(concat([referenced_schema_name],'.',[referenced_entity_name]))
ReferencedColumn_fullname
ReferencedColumn_fullname |
|
|
(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],'].[',[referenced_column_name],']'))
ReferencedColumn_fullname2
ReferencedColumn_fullname2 |
|
|
(concat([referenced_schema_name],'.',[referenced_entity_name],'.',[referenced_column_name]))
referencing_external_AntoraComponent
referencing_external_AntoraComponent |
|
|
referencing_external_AntoraModule
referencing_external_AntoraModule |
|
|
Referencing_fullname
Referencing_fullname |
|
|
(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],']'))
Referencing_fullname2
Referencing_fullname2 |
|
|
(concat([referencing_schema_name],'.',[referencing_entity_name]))
ReferencingColumn_fullname
ReferencingColumn_fullname |
|
|
(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],'].[',[referencing_column_name],']'))
ReferencingColumn_fullname2
ReferencingColumn_fullname2 |
|
|
(concat([referencing_schema_name],'.',[referencing_entity_name],'.',[referencing_column_name]))
sql_modules_definition
reference.RepoObjectColumn_ReferencedReferencing - V script
CREATE View [reference].[RepoObjectColumn_ReferencedReferencing]
As
--Select
-- Object2.RepoObject_fullname As Referenced_fullname
-- , Object2.RepoObject_fullname2 As Referenced_fullname2
-- , Object2.RepoObject_guid As Referenced_RepoObject_guid
-- , Object2.RepoObject_type As Referenced_type
-- , Object2.RepoObjectColumn_fullname As ReferencedColumn_fullname
-- , Object2.RepoObjectColumn_fullname2 As ReferencedColumn_fullname2
-- , Object2.RepoObjectColumn_name As ReferencedColumn_name
-- , Object2.RepoObjectColumn_type As ReferencedColumn_type
-- , Object2.RepoObjectColumn_guid As Referenced_guid
-- , Object1.RepoObject_fullname As Referencing_fullname
-- , Object1.RepoObject_fullname2 As Referencing_fullname2
-- , Object1.RepoObject_guid As Referencing_RepoObject_guid
-- , Object1.RepoObject_type As Referencing_type
-- , Object1.RepoObjectColumn_fullname As ReferencingColumn_fullname
-- , Object1.RepoObjectColumn_fullname2 As ReferencingColumn_fullname2
-- , Object1.RepoObjectColumn_name As ReferencingColumn_name
-- , Object1.RepoObjectColumn_type As ReferencingColumn_type
-- , Object1.RepoObjectColumn_guid As Referencing_guid
--From
-- graph.RepoObjectColumn As Object1
-- , graph.ReferencedObjectColumn As referenced
-- , graph.RepoObjectColumn As Object2
--Where Match(
-- Object1-(referenced)->Object2);
Select
Referenced_fullname = referenced_ro_fullname
, Referenced_fullname2 = referenced_ro_fullname2
, Referenced_RepoObject_guid = referenced_RepoObject_guid
, Referenced_type = referenced_type
, ReferencedColumn_fullname = referenced_roc_fullname
, ReferencedColumn_fullname2 = referenced_roc_fullname2
, ReferencedColumn_name = referenced_column_name
--, Object2.RepoObjectColumn_type As ReferencedColumn_type
, Referenced_guid = referenced_RepoObjectColumn_guid
, referenced_external_AntoraComponent
, referenced_external_AntoraModule
, referenced_is_external
, referenced_AntoraXref = Concat (
--* xref:target-page-filename.adoc[link text]
--we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
Cast('* xref:' As NVarchar(Max))
, referenced_external_AntoraComponent + ':'
, referenced_external_AntoraModule + ':'
, docs.fs_cleanStringForFilename ( referenced_ro_fullname2 )
, '.adoc#column-' + docs.fs_cleanStringForAnchorId ( referenced_column_name )
+ '[+' + referenced_roc_fullname2 + '+]'
, ' in xref:' + referenced_external_AntoraComponent + ':'
+ referenced_external_AntoraModule + ':' + 'nav/objects-by-schema.adoc[]'
)
, Referencing_fullname = referencing_ro_fullname
, Referencing_fullname2 = referencing_ro_fullname2
, Referencing_RepoObject_guid = referencing_RepoObject_guid
, Referencing_type = referencing_type
, ReferencingColumn_fullname = referencing_roc_fullname
, ReferencingColumn_fullname2 = referencing_roc_fullname2
, ReferencingColumn_name = referencing_column_name
--, Object1.RepoObjectColumn_type As ReferencingColumn_type
, Referencing_guid = referencing_RepoObjectColumn_guid
, referencing_external_AntoraComponent
, referencing_external_AntoraModule
, referencing_is_external
, referencing_AntoraXref = Concat (
--* xref:target-page-filename.adoc[link text]
--we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
Cast('* xref:' As NVarchar(Max))
, referencing_external_AntoraComponent + ':'
, referencing_external_AntoraModule + ':'
, docs.fs_cleanStringForFilename ( referencing_ro_fullname2 )
, '.adoc#column-' + docs.fs_cleanStringForAnchorId ( referencing_column_name )
+ '[+' + referencing_roc_fullname2 + '+]'
, ' in xref:' + referencing_external_AntoraComponent + ':'
+ referencing_external_AntoraModule + ':' + 'nav/objects-by-schema.adoc[]'
)
From
reference.RepoObjectColumn_reference_T