text: ﻿
  --Attention with *, if the source changes!
  CREATE View reference.RepoObjectColumn_ReferenceTree
  As
  Select
      tree.*
  From
      repo.RepoObjectColumn                                                                              As roc
      Cross Apply reference.ftv_RepoObjectColumn_ReferenceTree ( roc.RepoObjectColumn_guid, 1000, 1000 ) As tree
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObject_guid'
    , @value = '404679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '6b4679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'RepoObjectColumn_guid';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '664679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'ReferencingColumn_fullname';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '654679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referencing_type';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '644679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referencing_RepoObject_guid';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '684679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referencing_guid';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '634679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referencing_fullname';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '6a4679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referencing_Depth';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '604679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'ReferencedColumn_fullname';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '5f4679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referenced_type';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '5e4679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referenced_RepoObject_guid';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '624679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referenced_guid';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '5d4679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referenced_fullname';
  Go
  
  Execute sp_addextendedproperty
      @name = N'RepoObjectColumn_guid'
    , @value = '694679b8-147c-eb11-84e6-a81e8446d5b0'
    , @level0type = N'SCHEMA'
    , @level0name = N'reference'
    , @level1type = N'VIEW'
    , @level1name = N'RepoObjectColumn_ReferenceTree'
    , @level2type = N'COLUMN'
    , @level2name = N'Referenced_Depth';
  Go
  
  
  Go
  
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'RepoObjectColumn_guid', @value = '960e4ea4-c09b-eb11-84f6-a81e8446d5b0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree', @level2type = N'COLUMN', @level2name = N'ReferencingColumn_name';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'RepoObjectColumn_guid', @value = '950e4ea4-c09b-eb11-84f6-a81e8446d5b0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree', @level2type = N'COLUMN', @level2name = N'ReferencingColumn_fullname2';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'RepoObjectColumn_guid', @value = '940e4ea4-c09b-eb11-84f6-a81e8446d5b0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree', @level2type = N'COLUMN', @level2name = N'Referencing_fullname2';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'RepoObjectColumn_guid', @value = '930e4ea4-c09b-eb11-84f6-a81e8446d5b0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree', @level2type = N'COLUMN', @level2name = N'ReferencedColumn_name';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'RepoObjectColumn_guid', @value = '920e4ea4-c09b-eb11-84f6-a81e8446d5b0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree', @level2type = N'COLUMN', @level2name = N'ReferencedColumn_fullname2';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'RepoObjectColumn_guid', @value = '910e4ea4-c09b-eb11-84f6-a81e8446d5b0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree', @level2type = N'COLUMN', @level2name = N'Referenced_fullname2';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'ReferencedObjectList', @value = N'* [reference].[ftv_RepoObjectColumn_ReferenceTree]
  * [repo].[RepoObjectColumn]', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'AntoraReferencingList', @value = N'* xref:reference.ftv_RepoObject_ColumReferenceRepoObject.adoc[]', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'AntoraReferencedList', @value = N'* xref:reference.ftv_RepoObjectColumn_ReferenceTree.adoc[]
  * xref:repo.RepoObjectColumn.adoc[]', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'is_ssas', @value = N'0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree';
  
  
  GO
  EXECUTE sp_addextendedproperty @name = N'is_repo_managed', @value = N'0', @level0type = N'SCHEMA', @level0name = N'reference', @level1type = N'VIEW', @level1name = N'RepoObjectColumn_ReferenceTree';
  
  