configT.numbers_0_2047 - V

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

RepoObject_guid: 1DACB147-4AF5-EB11-850C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-configt.numbers_0_2047

Columns

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

int

NULL

low

int

NULL

int

NOT NULL

int

NULL

nchar(3)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-configt.numbers_0_2047

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-configt.numbers_0_2047

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-configt.numbers_0_2047

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-configt.numbers_0_2047

Column Reference Diagram

entity_1_1_colref-configt.numbers_0_2047

Column Details

_

high

high

int

NULL

Referenced Columns

low

low

int

NULL

Referenced Columns

number

number

int

NOT NULL

status

status

int

NULL

Referenced Columns

type

type

nchar(3)

NOT NULL

sql_modules_definition

configT.numbers_0_2047 - V script
/*
<<property_start>>Description
<<property_end>>
*/
CREATE View [configT].[numbers_0_2047]
As
Select
    number
  , type
  , low
  , high
  , status
From
    configT.spt_values
Where
    type = 'P'