repo.SysSchema_RepoSchema_via_name - V
type: V ( view ), modify_date: 2021-09-21 10:41:23
RepoObject_guid: B10747EC-8CA3-EB11-84FA-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_SysSchema_RepoSchema_via_name__1
-
IndexSemanticGroup: no_group
-
[column-RepoSchema_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_SysSchema_RepoSchema_via_name__2
-
IndexSemanticGroup: no_group
-
[column-RepoSchema_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
is_RepoSchema_name_uniqueidentifier
is_RepoSchema_name_uniqueidentifier |
|
|
Description
(case when TRY_CAST([RepoSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
Referenced Columns
is_SysSchema_name_uniqueidentifier
is_SysSchema_name_uniqueidentifier |
|
|
Description
(case when TRY_CAST([SysSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
Referenced Columns
sql_modules_definition
repo.SysSchema_RepoSchema_via_name - V script
CREATE View repo.SysSchema_RepoSchema_via_name
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
ss.SysSchema_name = rs.SysSchema_name
And rs.is_ssas = 0