View Dmv_Table_Info
Entity
Entity: Systems.Monitoring.TableInfo
Information about the tables in the database. Entity: Dmv_Table_Info (Introduced in version 23.1.2.43)
Summary
| Name |
Type |
Description |
| Row_Count |
bigint |
Total number of rows |
| Size_MB |
decimal(12, 3) |
Total used size of the table in Megabytes. |
| Table_Name |
nvarchar(128) |
The name of the table, for which we provide the data. |
Columns
Row_Count
Total number of rows
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Format |
N0 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
2147483647 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
yes |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
bigint |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Row_Count - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
| GreaterThanOrLessThan |
None |
no |
no |
Size_MB
Total used size of the table in Megabytes.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
2147483647 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
yes |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
decimal(12, 3) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Size_MB - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
| GreaterThanOrLessThan |
None |
no |
no |
Table_Name
The name of the table, for which we provide the data.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
128 |
| Order |
2147483647 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
yes |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
nvarchar(128) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Table_Name - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
| Like |
None |
no |
no |