ssas.model_json_311_tables_columns_T - U

type: U ( user table ), modify_date: 2022-09-05 18:18:08

RepoObject_guid: 646EC1CC-F00A-EC11-8516-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

entity-ssas.model_json_311_tables_columns_t

Columns

Table 1. Columns of ssas.model_json_311_tables_columns_T - U
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NOT NULL

2

nvarchar(128)

NOT NULL

3

nvarchar(128)

NOT NULL

uniqueidentifier

NOT NULL

Default: DF_model_json_311_tables_columns_T_RepoObjectColumn_guid
(newsequentialid())

uniqueidentifier

NOT NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

Persistence, History Table

  • persistence source: ssas.model_json_311_tables_columns - V

  • is_persistence: 1

  • is_persistence_check_duplicate_per_pk: 0

  • is_persistence_check_for_empty_source: 0

  • is_persistence_delete_changed: 0

  • is_persistence_delete_missing: 1

  • is_persistence_insert: 1

  • is_persistence_truncate: 0

  • is_persistence_update_changed: 1

  • has_history: 0

  • has_history_columns: 0

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_311_tables_columns_t

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_311_tables_columns_t

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_311_tables_columns_t

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_311_tables_columns_t

Column Reference Diagram

entity_1_1_colref-ssas.model_json_311_tables_columns_t

Indexes

PK_model_json_311_tables_columns_T

idx_model_json_311_tables_columns_T__1

idx_model_json_311_tables_columns_T__2

Column Details

_

tables_columns_description

tables_columns_description

nvarchar(max)

NULL

tables_columns_description_ja

tables_columns_description_ja

nvarchar(max)

NULL

tables_columns_displayFolder

tables_columns_displayFolder

nvarchar(500)

NULL

tables_columns_expression

tables_columns_expression

nvarchar(max)

NULL

tables_columns_expression_ja

tables_columns_expression_ja

nvarchar(max)

NULL

tables_columns_formatString

tables_columns_formatString

nvarchar(500)

NULL

tables_columns_isDataTypeInferred

tables_columns_isDataTypeInferred

bit

NULL

tables_columns_isHidden

tables_columns_isHidden

bit

NULL

tables_columns_isKey

tables_columns_isKey

bit

NULL

tables_columns_isNameInferred

tables_columns_isNameInferred

bit

NULL

tables_columns_isNullable

tables_columns_isNullable

bit

NULL

tables_columns_isUnique

tables_columns_isUnique

bit

NULL

tables_columns_keepUniqueRows

tables_columns_keepUniqueRows

bit

NULL

tables_columns_sortByColumn

tables_columns_sortByColumn

nvarchar(500)

NULL

tables_columns_sourceColumn

tables_columns_sourceColumn

nvarchar(500)

NULL

tables_columns_sourceProviderType

tables_columns_sourceProviderType

nvarchar(500)

NULL

tables_columns_summarizeBy

tables_columns_summarizeBy

nvarchar(500)

NULL