repo_sys.SysSchema - V

CREATE View repo_sys.SysSchema
As
--
Select
    SysSchema_id              = sch.schema_id
  , SysSchema_name            = sch.name Collate Database_Default
  , SysSchema_principal_id    = sch.principal_id
  , SysSchema_RepoSchema_guid = Try_Cast(ep.property_value As UniqueIdentifier)
From
    sys_dwh.schemas                 As sch
    Left Outer Join
        repo_sys.ExtendedProperties As ep
            On
            ep.major_id          = sch.schema_id
            And ep.minor_id      = 0
            And ep.class         = 3 /*class 3 - Schema*/
            And ep.property_name = N'RepoSchema_guid';

-- Where [sch].[name] <> 'sys'

sqlCopied!