uspgenerator.GeneratorUsp_persistence_tgt - V

type: V ( view ), modify_date: 2021-09-10 00:05:26

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

Description

Examples

Entity Diagram

entity-uspgenerator.generatorusp_persistence_tgt

Columns

Table 1. Columns of uspgenerator.GeneratorUsp_persistence_tgt - V
PK Column Name Data Type NULL? ID

tinyint

NOT NULL

id

int

NOT NULL

nvarchar(4000)

NULL

nvarchar(261)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-uspgenerator.generatorusp_persistence_tgt

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-uspgenerator.generatorusp_persistence_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-uspgenerator.generatorusp_persistence_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-uspgenerator.generatorusp_persistence_tgt

Column Reference Diagram

entity_1_1_colref-uspgenerator.generatorusp_persistence_tgt

Indexes

idx_GeneratorUsp_persistence_tgt__1

  • IndexSemanticGroup: no_group

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

idx_GeneratorUsp_persistence_tgt__2

Column Details

_

has_logging

has_logging

tinyint

NOT NULL

id

id

int

NOT NULL

Referenced Columns

usp_Description

usp_Description

nvarchar(4000)

NULL

usp_fullname

usp_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[usp_schema],'].[',[usp_name],']'))


usp_name

usp_name

nvarchar(128)

NOT NULL

usp_schema

usp_schema

nvarchar(128)

NOT NULL

sql_modules_definition

uspgenerator.GeneratorUsp_persistence_tgt - V script
CREATE View uspgenerator.GeneratorUsp_persistence_tgt
As
Select
    u.id
  , u.usp_schema
  , u.usp_name
  , u.has_logging
  , u.usp_Description
  , u.usp_fullname
From
    uspgenerator.GeneratorUsp As u
Where
    Left(u.usp_name, 12) = 'usp_PERSIST_'