ssas.model_json_3131111_tables_partitions_source_PosDot - V

type: V ( view ), modify_date: 2021-09-28 18:16:32

RepoObject_guid: B308A66B-7A20-EC11-8524-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_3131111_tables_partitions_source_posdot

Columns

Table 1. Columns of ssas.model_json_3131111_tables_partitions_source_PosDot - V
PK Column Name Data Type NULL? ID

nvarchar(128)

NOT NULL

bigint

NULL

bigint

NULL

bigint

NULL

bigint

NULL

uniqueidentifier

NOT NULL

nvarchar(max)

NULL

nvarchar(128)

NOT NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_3131111_tables_partitions_source_posdot

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_3131111_tables_partitions_source_posdot

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_3131111_tables_partitions_source_posdot

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_3131111_tables_partitions_source_posdot

Column Reference Diagram

entity_1_1_colref-ssas.model_json_3131111_tables_partitions_source_posdot

Indexes

idx_model_json_3131111_tables_partitions_source_PosDot__1

idx_model_json_3131111_tables_partitions_source_PosDot__2

idx_model_json_3131111_tables_partitions_source_PosDot__3

idx_model_json_3131111_tables_partitions_source_PosDot__4

Column Details

_

PosDot1

PosDot1

bigint

NULL

PosDot2

PosDot2

bigint

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

tables_partitions_source_dataSource

tables_partitions_source_dataSource

nvarchar(500)

NULL

tables_partitions_source_expression

tables_partitions_source_expression

nvarchar(max)

NULL

tables_partitions_source_name

tables_partitions_source_name

nvarchar(500)

NULL

tables_partitions_source_query

tables_partitions_source_query

nvarchar(max)

NULL

tables_partitions_source_query_ja

tables_partitions_source_query_ja

nvarchar(max)

NULL

tables_partitions_source_type

tables_partitions_source_type

nvarchar(500)

NULL

sql_modules_definition

ssas.model_json_3131111_tables_partitions_source_PosDot - V script
CREATE View ssas.model_json_3131111_tables_partitions_source_PosDot
As
Select
    databasename
  , tables_name
  , RepoObject_guid
  , tables_partitions_name
  , tables_partitions_source_name
  , tables_partitions_source_dataSource
  , tables_partitions_source_expression
  , tables_partitions_source_query
  , tables_partitions_source_query_ja
  , tables_partitions_source_type
  , PosFrom
  , PosFromWhere
  , StringFrom
  , PosDot1 = CharIndex ( '.', StringFrom )
  , PosDot2 = CharIndex ( '.', StringFrom, CharIndex ( '.', StringFrom ) + 1 )
From
    ssas.model_json_313111_tables_partitions_source_StringFrom