Table Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
- Implements
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, ICollection<OverrideCollection>) |
Obsolete.
Deprecated. Use RequestRefresh method instead. |
Refresh(RefreshType) |
Obsolete.
Deprecated. Use RequestRefresh method instead. |
Rename(String) |
Obsolete.
Deprecated. Use RequestRename method instead. |
RequestRefresh(RefreshType, DateTime) |
Request refresh of this object. |
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, ICollection<OverrideCollection>) |
Request refresh of this object with overrides. |
RequestRefresh(RefreshType, RefreshPolicyBehavior) |
Request refresh of this object. |
RequestRefresh(RefreshType) |
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) |