configT.type - V

/*
<<property_start>>Description
* based on master.dbo.spt_values, which  is an undocumemted hidden view or table, containing useful entries
* master.dbo.spt_values content is available as copy in xref:sqldb:configt.spt_values.adoc[]
<<property_end>>
*/
CREATE View [configT].[type]
As
--
Select
    type          = Trim ( T1.type )
  , type_desc     = Trim ( T1.type_desc )
  , is_DocsOutput = Case
                        When T1.type In
                        ( 'U', 'V', 'FN', 'FS', 'FT', 'IF', 'IS', 'P', 'PC', 'SN', 'SO', 'TF', 'TR', 'X' )
                            Then
                            1
                        Else
                            0
                    End
From
(
    Select
        type      = ParseName ( Replace ( name, ':', '.' ), 2 )
      , type_desc = Trim ( ParseName ( Replace ( name, ':', '.' ), 1 ))
    From
        configT.spt_values
    Where
        type       = 'O9T'
        And number = -1
) As T1

sqlCopied!