Table Properties Dialog Box (SSAS - Tabular)

Use the Table Properties dialog box in SQL Server Management Studio to view the properties of a table in a tabular model database. All properties are read-only.

You can display the Table Properties dialog box by right-clicking a table in Object Explorer and selecting Properties.

Options

Term

Definition

Name

Displays the name of the table.

ID

Displays the identifier of the table.

Description

Displays the description of the table.

Create Timestamp

Displays the date and time the table was created.

Last Schema Update

Displays the date and time the metadata for the table was last updated.

State

Displays the processing state of the table. For more information about the values for this property, see State.

Last Processed

Displays the date and time the table was last processed.

Current Storage Mode

Displays the current storage mode for the table. Storage mode is set at the database level and inherited by all tables. You cannot use different storage modes at the table level. Valid values are InMemory (default), InMemoryWithDirectQuery, DirectQuery, DirectQueryWithinMemory.