configT.join_type - V

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

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

Description

Examples

Entity Diagram

entity-configt.join_type

Columns

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

1

varchar(16)

NOT NULL

varchar(16)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-configt.join_type

References

Object Reference Diagram - 1 1

entity_1_1_objectref-configt.join_type

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-configt.join_type

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-configt.join_type

Column Reference Diagram

entity_1_1_colref-configt.join_type

Indexes

PK_join_type

Column Details

_

join_type

1

join_type

varchar(16)

NOT NULL

join_type_variant

join_type_variant

varchar(16)

NOT NULL

sql_modules_definition

configT.join_type - V script
/*
<<property_start>>Description
<<property_end>>
*/
CREATE View [configT].[join_type]
As
--
Select
    join_type_variant = 'INNER JOIN'
  , join_type         = 'INNER JOIN'
Union All
Select
    join_type_variant = 'LEFT OUTER JOIN'
  , join_type         = 'LEFT OUTER JOIN'
Union All
Select
    join_type_variant = 'LEFT JOIN'
  , join_type         = 'LEFT OUTER JOIN'
Union All
Select
    join_type_variant = 'RIGHT OUTER JOIN'
  , join_type         = 'RIGHT OUTER JOIN'
Union All
Select
    join_type_variant = 'RIGHT JOIN'
  , join_type         = 'RIGHT OUTER JOIN'
Union All
Select
    join_type_variant = 'FULL OUTER JOIN'
  , join_type         = 'FULL OUTER JOIN'
Union All
Select
    join_type_variant = 'CROSS JOIN'
  , join_type         = 'CROSS JOIN'