INFO.TABLES DAX Function (Information)
Returns a list of all tables in the current model with columns matching the schema rowset for table objects.
Syntax
INFO.TABLES ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )
| Parameter | Attributes | Description |
|---|---|---|
| RestrictionName | Optional Repeatable |
Restriction name. |
| RestrictionValue | Optional Repeatable |
Restriction value. |
Return values
Table An entire table or a table with one or more columns.
| Field | Type |
|---|---|
| ID | Integer |
| ModelID | Integer |
| Name | String |
| DataCategory | String |
| Description | String |
| IsHidden | Boolean |
| TableStorageID | Integer |
| ModifiedTime | DateTime |
| StructureModifiedTime | DateTime |
| SystemFlags | Integer |
| ShowAsVariationsOnly | Boolean |
| IsPrivate | Boolean |
| DefaultDetailRowsDefinitionID | Integer |
| AlternateSourcePrecedence | Integer |
| RefreshPolicyID | Integer |
| CalculationGroupID | Integer |
| ExcludeFromModelRefresh | Boolean |
| LineageTag | String |
| SourceLineageTag | String |
| SystemManaged | Boolean |
| ExcludeFromAutomaticAggregations | Boolean |
Remarks
Corresponds to the TMSCHEMA_TABLES data management view (DMV).
As all the INFO functions, it cannot be used in calculated tables and calculated columns.
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies