Table Class

Definition

Namespace:

Microsoft.AnalysisServices.Tabular

Assembly:

Microsoft.AnalysisServices.Tabular.dll

Package:

Microsoft.AnalysisServices.retail.amd64 v19.79.0

Represents a Table in the data model. A Table object is a member of the TableCollection object under a Model object. It contains a ColumnCollection. Rows are based on Partition object or a CalculatedPartitionSource if the Table is a calculated table.

public sealed class Table : Microsoft.AnalysisServices.Tabular.NamedMetadataObject, Microsoft.AnalysisServices.Tabular.IMetadataObjectWithLineage

type Table = class
    inherit NamedMetadataObject
    interface IMetadataObjectWithLineage

Public NotInheritable Class Table
Inherits NamedMetadataObject
Implements IMetadataObjectWithLineage

Inheritance

Object

MetadataObject

NamedMetadataObject

Table

Implements

IMetadataObjectWithLineage

Constructors

Table()

Create a new instance of the Table class with default settings.

Properties

AlternateSourcePrecedence	The ranking or precedence used to select the alternate source table in case more than one match is found.
Annotations	Gets the collection object of all annotations in the current Table.
CalculationGroup	CalculationGroup reference.
ChangedProperties	Gets the collection object of all changedproperties in the current Table.
Columns	Gets the collection object of all columns in the current Table.
DataCategory	Specifies the type of Table so that you can customize application behavior based on the type of data in the table. Allowed values are identical to those of dimension type properties for Multidimensional models. Regular is the default. Other values include Time (2), Geography (3), Organization (4), BillOfMaterials (5), Accounts (6), Customers (7), Products (8), Scenario (9), Quantitativ1e (10), Utility (11), Currency (12), Rates (13), Channel (14) - channel dimension, Promotion (15).
DefaultDetailRowsDefinition	Defines the default DAX expression to apply when drilling through to the detail rows for measures in this table.
Description	The description of the table, visible to developers at design time and to administrators in management tools, such as SQL Server Management Studio.
ExcludeFromAutomaticAggregations	An indication whether the table is excluded from the automatic aggregations feature.
ExcludeFromModelRefresh	A boolean value that indicates whether the table is excluded from model refresh. When this is true, a refresh operation on the model would not trigger a refresh on the partitions of the table if they were already processed.
ExtendedProperties	Gets the collection object of all extendedproperties in the current Table.
Hierarchies	Gets the collection object of all hierarchies in the current Table.
IsHidden	A boolean value that indicates whether the table is treated as hidden by client visualization tools. True if the Table is treated as hidden; otherwise false.
IsPrivate	A boolean value that specifies whether to hide a table from the client. True hides the tables.
IsRemoved	A Boolean specifying whether this object was removed from an object tree. (Inherited from MetadataObject)
LineageTag	A tag that represents the lineage of the object.
Measures	Gets the collection object of all measures in the current Table.
Model	Gets the Tabular model that contains this object. (Inherited from MetadataObject)
ModifiedTime	The time that the object was last modified.
Name	Gets or Sets the Name of this object.
ObjectType	Gets the type of the object.
Parent	Parent object, null for Model objects.
Partitions	Gets the collection object of all partitions in the current Table.
RefreshPolicy	Refresh policy for the table.
Sets	Gets the collection object of all sets in the current Table.
ShowAsVariationsOnly	A boolean value that indicates a difference between a local and server version. If True, the Table is only shown when referenced as Variation.
SourceLineageTag	A tag that represents the lineage of the source for the object.
StructureModifiedTime	The time that the structure of the object was last modified.
SystemManaged	A boolean value that indicates whether the table is managed by the system. The system takes ownership of creation and deletion of such tables.

Methods

ApplyRefreshPolicy(Boolean, Int32)	Adjusting the partitioning scheme of the table, determined by the refresh-policy that is associated with it when the effective date that is used is based on the current time.
ApplyRefreshPolicy(DateTime, Boolean, Int32)	Adjusting the partitioning scheme of the table, determined by the refresh-policy that is associated with it and the specified effective date.
Clone()	Creates a new, full copy of a Table object.
CopyFrom(Table)	Obsolete. Deprecated. Use CopyTo method instead.
CopyTo(Table)	Copies a Table object to the specified object.
Refresh(RefreshType)	Obsolete. Deprecated. Use RequestRefresh method instead.
Refresh(RefreshType, ICollection<OverrideCollection>)	Obsolete. Deprecated. Use RequestRefresh method instead.
Rename(String)	Obsolete. Deprecated. Use RequestRename method instead.
RequestRefresh(RefreshType)	Request refresh of this object.
RequestRefresh(RefreshType, DateTime)	Request refresh of this object.
RequestRefresh(RefreshType, ICollection<OverrideCollection>)	Request refresh of this object with overrides.
RequestRefresh(RefreshType, ICollection<OverrideCollection>, DateTime)	Request refresh of this object with overrides.
RequestRefresh(RefreshType, ICollection<OverrideCollection>, RefreshPolicyBehavior)	Request refresh of this object with overrides.
RequestRefresh(RefreshType, RefreshPolicyBehavior)	Request refresh of this object.
RequestRename(String)	Request rename of this object.
Validate()	This API supports the product infrastructure and is not intended to be used directly from your code. Microsoft Internal Use Only. (Inherited from MetadataObject)