configT.type - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: D98F291C-9D61-EB11-84DC-A81E8446D5B0

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 configT.spt_values - U

Examples

Entity Diagram

entity-configt.type

Columns

Table 1. Columns of configT.type - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NULL

int

NOT NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-configt.type

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-configt.type

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-configt.type

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-configt.type

Column Reference Diagram

entity_1_1_colref-configt.type

Indexes

PK_type

  • IndexSemanticGroup: no_group

    • type; nvarchar(128)

  • PK, Unique, Real: 1, 1, 0

sql_modules_definition

configT.type - V script
/*
<<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