repo.SysObject_RepoObject_via_guid - V

type: V ( view ), modify_date: 2021-09-21 18:26:12

RepoObject_guid: 5B90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.sysobject_repoobject_via_guid

Columns

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

uniqueidentifier

NULL

int

NULL

bit

NULL

bit

NULL

int

NULL

bit

NULL

int

NULL

datetime

NOT NULL

int

NOT NULL

uniqueidentifier

NULL

tinyint

NULL

uniqueidentifier

NULL

bit

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

int

NULL

datetime

NULL

nvarchar(128)

NULL

int

NULL

nvarchar(128)

NULL

char(2)

NULL

char(2)

NULL

int

NOT NULL

sysname

NOT NULL

uniqueidentifier

NULL

sysname

NULL

char(2)

NULL

nvarchar(60)

NULL

tinyint

NULL

Foreign Key Diagram

entity_1_1_fk-repo.sysobject_repoobject_via_guid

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.sysobject_repoobject_via_guid

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.sysobject_repoobject_via_guid

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.sysobject_repoobject_via_guid

Column Reference Diagram

entity_1_1_colref-repo.sysobject_repoobject_via_guid

Indexes

idx_SysObject_RepoObject_via_guid__1

idx_SysObject_RepoObject_via_guid__2

idx_SysObject_RepoObject_via_guid__3

idx_SysObject_RepoObject_via_guid__4

Column Details

_

history_table_guid

history_table_guid

uniqueidentifier

NULL

Referenced Columns

history_table_id

history_table_id

int

NULL

is_external

is_external

bit

NULL

Referenced Columns

is_repo_managed

is_repo_managed

bit

NULL

Referenced Columns

is_RepoObject_name_uniqueidentifier

is_RepoObject_name_uniqueidentifier

int

NULL

Description

(case when TRY_CAST([RepoObject_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)


is_ssas

is_ssas

bit

NULL

Referenced Columns

is_SysObject_name_uniqueidentifier

is_SysObject_name_uniqueidentifier

int

NULL

Description

(case when TRY_CAST([SysObject_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)


modify_date

modify_date

datetime

NOT NULL

Referenced Columns

parent_object_id

parent_object_id

int

NOT NULL

Repo_history_table_guid

Repo_history_table_guid

uniqueidentifier

NULL

Repo_temporal_type

Repo_temporal_type

tinyint

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NULL

Referenced Columns

RepoObject_is_SysObject_missing

RepoObject_is_SysObject_missing

bit

NULL

RepoObject_name

RepoObject_name

nvarchar(128)

NULL

Referenced Columns

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NULL

RepoObject_SysObject_id

RepoObject_SysObject_id

int

NULL

Referenced Columns

RepoObject_SysObject_modify_date

RepoObject_SysObject_modify_date

datetime

NULL

RepoObject_SysObject_name

RepoObject_SysObject_name

nvarchar(128)

NULL

Referenced Columns

RepoObject_SysObject_parent_object_id

RepoObject_SysObject_parent_object_id

int

NULL

RepoObject_SysObject_schema_name

RepoObject_SysObject_schema_name

nvarchar(128)

NULL

RepoObject_SysObject_type

RepoObject_SysObject_type

char(2)

NULL

Referenced Columns

RepoObject_type

RepoObject_type

char(2)

NULL

Referenced Columns

SysObject_id

SysObject_id

int

NOT NULL

Referenced Columns

SysObject_name

SysObject_name

sysname

NOT NULL

SysObject_RepoObject_guid

SysObject_RepoObject_guid

uniqueidentifier

NULL

SysObject_schema_name

SysObject_schema_name

sysname

NULL

SysObject_type

SysObject_type

char(2)

NULL

Referenced Columns

SysObject_type_desc

SysObject_type_desc

nvarchar(60)

NULL

Referenced Columns

temporal_type

temporal_type

tinyint

NULL

sql_modules_definition

repo.SysObject_RepoObject_via_guid - V script
CREATE View repo.SysObject_RepoObject_via_guid
As
--
Select
    so.SysObject_id
  , ro.is_repo_managed
  , so.SysObject_schema_name
  , so.SysObject_name
  , SysObject_type                        = so.type
  , SysObject_type_desc                   = so.type_desc
  , modify_date                           = so.modify_date
  , parent_object_id                      = so.parent_object_id
  , SysObject_RepoObject_guid             = so.SysObject_RepoObject_guid
  , history_table_guid                    = ro_hist.RepoObject_guid
  , so.history_table_id
  , so.temporal_type
  --, [so].[max_column_id_used] AS         [SysObject_max_column_id_used]
  , ro.Repo_history_table_guid
  , ro.Repo_temporal_type
  , RepoObject_guid                       = ro.RepoObject_guid
  , ro.RepoObject_schema_name
  , ro.RepoObject_name
  , ro.RepoObject_type
  , RepoObject_SysObject_id               = ro.SysObject_id
  , RepoObject_SysObject_schema_name      = ro.SysObject_schema_name
  , RepoObject_SysObject_name             = ro.SysObject_name
  , RepoObject_SysObject_type             = ro.SysObject_type
  , RepoObject_SysObject_modify_date      = ro.SysObject_modify_date
  , RepoObject_SysObject_parent_object_id = ro.SysObject_parent_object_id
  , RepoObject_is_SysObject_missing       = ro.is_SysObject_missing
  , ro.is_RepoObject_name_uniqueidentifier
  , ro.is_SysObject_name_uniqueidentifier
  , ro.is_ssas
  , ro.is_external
--, [ro].SysObject_parent_object_id AS          [RepoObject_parent_SysObject_id]
--, [ro].[SysObject_temporal_type] AS      [RepoObject_SysObject_temporal_type]
--, [ro].[SysObject_history_table_id] AS   [RepoObject_SysObject_history_table_id]
--, [ro].[SysObject_max_column_id_used] AS [RepoObject_SysObject_max_column_id_used]
From
    repo_sys.SysObject  As so
    Left Outer Join
        repo.RepoObject As ro
            On
            ro.RepoObject_guid      = so.SysObject_RepoObject_guid
            And ro.is_ssas          = 0
            And ro.is_external      = 0

    Left Outer Join
        repo.RepoObject As ro_hist
            On
            ro_hist.SysObject_id    = so.history_table_id
            And ro_hist.is_ssas     = 0
            And ro_hist.is_external = 0