ssas.model_json_3132_tables_partitions_PosFrom - V
type: V ( view ), modify_date: 2021-09-28 17:42:24
RepoObject_guid: B508A66B-7A20-EC11-8524-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_model_json_3132_tables_partitions_PosFrom__1
-
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_3132_tables_partitions_PosFrom__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3132_tables_partitions_PosFrom__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
tables_partitions_annotations_ja
tables_partitions_annotations_ja |
|
|
tables_partitions_dataView
tables_partitions_dataView |
|
|
tables_partitions_mode
tables_partitions_mode |
|
|
tables_partitions_name
tables_partitions_name |
|
|
sql_modules_definition
ssas.model_json_3132_tables_partitions_PosFrom - V script
CREATE VIEW [ssas].[model_json_3132_tables_partitions_PosFrom]
As
Select
databasename
, tables_name
, RepoObject_guid
, tables_partitions_name
, tables_partitions_annotations_ja
, tables_partitions_dataView
, tables_partitions_mode
, tables_partitions_source_j
, PosFrom = CharIndex ( ' from ', tables_partitions_source_j )
, PosFromDoublequota = CharIndex (
'"'
, tables_partitions_source_j
, CharIndex ( ' from ', tables_partitions_source_j ) + 6
)
, PosFromWhere = CharIndex (
' where '
, tables_partitions_source_j
, CharIndex ( ' from ', tables_partitions_source_j ) + 6
)
From
ssas.model_json_313_tables_partitions