Systems.Dmv.TableInfo View
Namespace: Systems.Dmv
Information about the tables in the database. Entity: Dmv_Table_Info (Introduced in version 23.1.2.43)
Default Visualization
Default Display Text Format:
{TableName}: {SizeMB}
Default Search Members:
__
Category: Views
Show in UI: ShownByDefault
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| RowCount | int64 | Total number of rows. Required Filter(eq;ge;le) ORD |
| SizeMB | decimal (12, 3) | Total used size of the table in Megabytes. Required Filter(eq;ge;le) ORD |
| TableName | string (128) | The name of the table, for which we provide the data. Required Filter(eq;like) ORD |
Attribute Details
RowCount
Total number of rows. Required Filter(eq;ge;le) ORD
Type: int64
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
SizeMB
Total used size of the table in Megabytes. Required Filter(eq;ge;le) ORD
Type: decimal (12, 3)
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
TableName
The name of the table, for which we provide the data. Required Filter(eq;like) ORD
Type: string (128)
Category: System
Supported Filters: Equals, Like
Supports Order By: True
Maximum Length: 128
Show in UI: ShownByDefault
API
Domain API Query: https://demodb.my.erp.net/api/domain/odata/Systems_Dmv_TableInfo?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Systems_Dmv_TableInfo?$top=10