repo.RepoObject_external_tgt - V

type: V ( view ), modify_date: 2021-09-20 21:32:29

RepoObject_guid: 0EFE2E93-491A-EC11-851F-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject_external_tgt

Columns

Table 1. Columns of repo.RepoObject_external_tgt - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NULL

bit

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

tinyint

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NOT NULL

bit

NULL

datetime

NOT NULL

uniqueidentifier

NULL

nvarchar(4000)

NULL

uniqueidentifier

NULL

tinyint

NULL

nvarchar(128)

NOT NULL

int

NULL

nvarchar(128)

NOT NULL

char(2)

NOT NULL

int

NULL

datetime

NULL

nvarchar(128)

NOT NULL

int

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NULL

Persistence, History Table

  • persistence source: repo.RepoObject_external_src - V

  • is_persistence: 1

  • is_persistence_check_duplicate_per_pk: 0

  • is_persistence_check_for_empty_source: 0

  • is_persistence_delete_changed: 0

  • is_persistence_delete_missing: 1

  • is_persistence_insert: 1

  • is_persistence_truncate: 0

  • is_persistence_update_changed: 1

  • has_history: 0

  • has_history_columns: 0

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_external_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_external_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_external_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_external_tgt

Column Reference Diagram

entity_1_1_colref-repo.repoobject_external_tgt

Indexes

PK_RepoObject_external_tgt

UK_RepoObject_external_tgt__2

UK_RepoObject_external_tgt__3

UK_RepoObject_external_tgt__4

idx_RepoObject_external_tgt__5

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

external_AntoraComponent

external_AntoraComponent

nvarchar(128)

NULL

external_AntoraModule

external_AntoraModule

nvarchar(128)

NULL

has_execution_plan_issue

has_execution_plan_issue

bit

NULL

has_get_referenced_issue

has_get_referenced_issue

bit

NULL

Inheritance_StringAggSeparatorSql

Inheritance_StringAggSeparatorSql

nvarchar(4000)

NULL

InheritanceDefinition

InheritanceDefinition

nvarchar(4000)

NULL

InheritanceType

InheritanceType

tinyint

NULL

Referenced Columns

is_external

is_external

bit

NULL

is_repo_managed

is_repo_managed

bit

NULL

is_required_ObjectMerge

is_required_ObjectMerge

bit

NULL

is_ssas

is_ssas

bit

NOT NULL

Referenced Columns

is_SysObject_missing

is_SysObject_missing

bit

NULL

modify_dt

modify_dt

datetime

NOT NULL

Referenced Columns

pk_index_guid

pk_index_guid

uniqueidentifier

NULL

Referenced Columns

pk_IndexPatternColumnName_new

pk_IndexPatternColumnName_new

nvarchar(4000)

NULL

Repo_history_table_guid

Repo_history_table_guid

uniqueidentifier

NULL

Repo_temporal_type

Repo_temporal_type

tinyint

NULL

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

RepoObject_Referencing_Count

RepoObject_Referencing_Count

int

NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObject_type

RepoObject_type

char(2)

NOT NULL

SysObject_id

SysObject_id

int

NULL

Referenced Columns

SysObject_modify_date

SysObject_modify_date

datetime

NULL

SysObject_name

SysObject_name

nvarchar(128)

NOT NULL

SysObject_parent_object_id

SysObject_parent_object_id

int

NOT NULL

SysObject_schema_name

SysObject_schema_name

nvarchar(128)

NOT NULL

SysObject_type

SysObject_type

char(2)

NULL

sql_modules_definition

repo.RepoObject_external_tgt - V script
Create View repo.RepoObject_external_tgt
As
Select
    RepoObject_guid
  , has_execution_plan_issue
  , has_get_referenced_issue
  , Inheritance_StringAggSeparatorSql
  , InheritanceDefinition
  , InheritanceType
  , is_required_ObjectMerge
  , is_repo_managed
  , is_ssas
  , is_SysObject_missing
  , modify_dt
  , pk_index_guid
  , pk_IndexPatternColumnName_new
  , Repo_history_table_guid
  , Repo_temporal_type
  , RepoObject_name
  , RepoObject_Referencing_Count
  , RepoObject_schema_name
  , RepoObject_type
  , SysObject_id
  , SysObject_modify_date
  , SysObject_name
  , SysObject_parent_object_id
  , SysObject_schema_name
  , SysObject_type
  , external_AntoraComponent
  , external_AntoraModule
  , is_external
From
    repo.RepoObject
Where
    is_external = 1