repo.RepoObjectColumn_external_tgt - V

type: V ( view ), modify_date: 2022-09-05 17:05:53

RepoObject_guid: C3D025E7-1A1B-EC11-8520-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobjectcolumn_external_tgt

Columns

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

1

uniqueidentifier

NOT NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

tinyint

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

uniqueidentifier

NULL

int

NULL

nvarchar(max)

NULL

bit

NULL

nvarchar(128)

NULL

nvarchar(max)

NULL

tinyint

NOT NULL

int

NULL

sql_variant

NULL

bit

NOT NULL

bit

NOT NULL

bit

NULL

bit

NULL

sql_variant

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NULL

uniqueidentifier

NOT NULL

int

NULL

nvarchar(128)

NOT NULL

int

NULL

nvarchar(128)

NOT NULL

Persistence, History Table

  • persistence source: repo.RepoObjectColumn_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.repoobjectcolumn_external_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobjectcolumn_external_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobjectcolumn_external_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobjectcolumn_external_tgt

Column Reference Diagram

entity_1_1_colref-repo.repoobjectcolumn_external_tgt

Indexes

PK_RepoObjectColumn_external_tgt

UK_RepoObjectColumn_external_tgt__2

UK_RepoObjectColumn_external_tgt__3

idx_RepoObjectColumn_external_tgt__4

idx_RepoObjectColumn_external_tgt__5

idx_RepoObjectColumn_external_tgt__6

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Inheritance_StringAggSeparatorSql

Inheritance_StringAggSeparatorSql

nvarchar(4000)

NULL

InheritanceDefinition

InheritanceDefinition

nvarchar(4000)

NULL

InheritanceType

InheritanceType

tinyint

NULL

is_persistence_Ignore

is_persistence_Ignore

bit

NULL

is_persistence_NoCompareButUpdate

is_persistence_NoCompareButUpdate

bit

NULL

is_persistence_NoCompareNoUpdate

is_persistence_NoCompareNoUpdate

bit

NULL

is_persistence_NoInsert

is_persistence_NoInsert

bit

NULL

is_query_plan_expression

is_query_plan_expression

bit

NULL

is_required_ColumnMerge

is_required_ColumnMerge

bit

NULL

is_SysObjectColumn_missing

is_SysObjectColumn_missing

bit

NULL

persistence_source_RepoObjectColumn_guid

persistence_source_RepoObjectColumn_guid

uniqueidentifier

NULL

Referencing_Count

Referencing_Count

int

NULL

Repo_default_definition

Repo_default_definition

nvarchar(max)

NULL

Repo_default_is_system_named

Repo_default_is_system_named

bit

NULL

Repo_default_name

Repo_default_name

nvarchar(128)

NULL

Repo_definition

Repo_definition

nvarchar(max)

NULL

Repo_generated_always_type

Repo_generated_always_type

tinyint

NOT NULL

Repo_graph_type

Repo_graph_type

int

NULL

Repo_increment_value

Repo_increment_value

sql_variant

NULL

Repo_is_computed

Repo_is_computed

bit

NOT NULL

Repo_is_identity

Repo_is_identity

bit

NOT NULL

Repo_is_nullable

Repo_is_nullable

bit

NULL

Repo_is_persisted

Repo_is_persisted

bit

NULL

Repo_seed_value

Repo_seed_value

sql_variant

NULL

Repo_user_type_fullname

Repo_user_type_fullname

nvarchar(128)

NULL

Repo_user_type_name

Repo_user_type_name

nvarchar(128)

NULL

Repo_uses_database_collation

Repo_uses_database_collation

bit

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_column_id

RepoObjectColumn_column_id

int

NULL

RepoObjectColumn_name

RepoObjectColumn_name

nvarchar(128)

NOT NULL

SysObjectColumn_column_id

SysObjectColumn_column_id

int

NULL

SysObjectColumn_name

SysObjectColumn_name

nvarchar(128)

NOT NULL

sql_modules_definition

repo.RepoObjectColumn_external_tgt - V script
CREATE View [repo].[RepoObjectColumn_external_tgt]
As
Select
    T1.RepoObjectColumn_guid
  , T1.Inheritance_StringAggSeparatorSql
  , T1.InheritanceDefinition
  , T1.InheritanceType
  , T1.is_persistence_Ignore
  , T1.is_persistence_NoCompareButUpdate
  , T1.is_persistence_NoCompareNoUpdate
  , T1.is_persistence_NoInsert
  , T1.is_query_plan_expression
  , T1.is_required_ColumnMerge
  , T1.is_SysObjectColumn_missing
  , T1.persistence_source_RepoObjectColumn_guid
  , T1.Referencing_Count
  , T1.Repo_default_definition
  , T1.Repo_default_is_system_named
  , T1.Repo_default_name
  , T1.Repo_definition
  , T1.Repo_generated_always_type
  , T1.Repo_graph_type
  , T1.Repo_is_computed
  , T1.Repo_is_identity
  , T1.Repo_is_nullable
  , T1.Repo_is_persisted
  , T1.Repo_seed_value
  , T1.Repo_increment_value
  , T1.Repo_user_type_name
  , T1.Repo_user_type_fullname
  , T1.Repo_uses_database_collation
  , T1.RepoObjectColumn_column_id
  , T1.RepoObjectColumn_name
  , T1.RepoObject_guid
  , T1.SysObjectColumn_column_id
  , T1.SysObjectColumn_name
From
    repo.RepoObjectColumn As T1
Where
    Exists
(
    Select
        1
    From
        repo.RepoObject_external_tgt As T2
    Where
        T2.RepoObject_guid = T1.RepoObject_guid
)