ssas.model_json_31311_tables_partitions_source_PosFrom - V
type: V ( view ), modify_date: 2021-09-28 18:12:57
RepoObject_guid: B108A66B-7A20-EC11-8524-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_model_json_31311_tables_partitions_source_PosFrom__1
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
[column-tables_partitions_name]; nvarchar(500)
-
[column-tables_partitions_source_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_31311_tables_partitions_source_PosFrom__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
[column-tables_partitions_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_31311_tables_partitions_source_PosFrom__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_31311_tables_partitions_source_PosFrom__4
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
tables_partitions_source_dataSource
tables_partitions_source_dataSource |
|
|
tables_partitions_source_expression
tables_partitions_source_expression |
|
|
sql_modules_definition
ssas.model_json_31311_tables_partitions_source_PosFrom - V script
CREATE View ssas.model_json_31311_tables_partitions_source_PosFrom
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 = CharIndex ( ' from ', tables_partitions_source_query )
, PosFromWhere = CharIndex (
' where '
, tables_partitions_source_query
, CharIndex ( ' from ', tables_partitions_source_query ) + 6
)
From
ssas.model_json_3131_tables_partitions_source