repo.SysSchema_RepoSchema_via_guid - V

type: V ( view ), modify_date: 2021-09-21 10:40:43

RepoObject_guid: B00747EC-8CA3-EB11-84FA-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.sysschema_reposchema_via_guid

Columns

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

int

NULL

int

NULL

uniqueidentifier

NULL

bit

NULL

nvarchar(128)

NULL

int

NULL

nvarchar(128)

NULL

int

NOT NULL

sysname

NOT NULL

uniqueidentifier

NULL

Foreign Key Diagram

entity_1_1_fk-repo.sysschema_reposchema_via_guid

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.sysschema_reposchema_via_guid

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.sysschema_reposchema_via_guid

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.sysschema_reposchema_via_guid

Column Reference Diagram

entity_1_1_colref-repo.sysschema_reposchema_via_guid

Indexes

idx_SysSchema_RepoSchema_via_guid__1

idx_SysSchema_RepoSchema_via_guid__2

Column Details

_

is_RepoSchema_name_uniqueidentifier

is_RepoSchema_name_uniqueidentifier

int

NULL

Description

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


is_SysSchema_name_uniqueidentifier

is_SysSchema_name_uniqueidentifier

int

NULL

Description

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


RepoSchema_guid

RepoSchema_guid

uniqueidentifier

NULL

Referenced Columns

RepoSchema_is_SysSchema_missing

RepoSchema_is_SysSchema_missing

bit

NULL

RepoSchema_name

RepoSchema_name

nvarchar(128)

NULL

Referenced Columns

RepoSchema_SysSchema_id

RepoSchema_SysSchema_id

int

NULL

Referenced Columns

RepoSchema_SysSchema_name

RepoSchema_SysSchema_name

nvarchar(128)

NULL

Referenced Columns

SysSchema_id

SysSchema_id

int

NOT NULL

Referenced Columns

SysSchema_name

SysSchema_name

sysname

NOT NULL

SysSchema_RepoSchema_guid

SysSchema_RepoSchema_guid

uniqueidentifier

NULL

sql_modules_definition

repo.SysSchema_RepoSchema_via_guid - V script
CREATE View repo.SysSchema_RepoSchema_via_guid
As
--
Select
    ss.SysSchema_id
  , ss.SysSchema_name
  , SysSchema_RepoSchema_guid       = ss.SysSchema_RepoSchema_guid
  , RepoSchema_guid                 = rs.RepoSchema_guid
  , rs.RepoSchema_name
  , RepoSchema_SysSchema_id         = rs.SysSchema_id
  , RepoSchema_SysSchema_name       = rs.SysSchema_name
  , RepoSchema_is_SysSchema_missing = rs.is_SysSchema_missing
  , rs.is_RepoSchema_name_uniqueidentifier
  , rs.is_SysSchema_name_uniqueidentifier
From
    repo_sys.SysSchema  As ss
    Left Outer Join
        repo.RepoSchema As rs
            On
            rs.RepoSchema_guid = ss.SysSchema_RepoSchema_guid
            And rs.is_ssas     = 0