Table 8700 Table Information Cache in 26
- App
- System Application
- Namespace
- System.DataAdministration
Versions171819202122232425262728latest
Source in 26
src/System Application/App/Table Information/src/TableInformationCache.Table.al81 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace System.DataAdministration;
table 8700 "Table Information Cache"
{
DataPerCompany = false;
ReplicateData = false;
Access = Internal;
DataClassification = SystemMetadata;
InherentEntitlements = X;
InherentPermissions = X;
fields
{
field(1; "Company Name"; Text[30])
{
Caption = 'Company Name';
}
field(2; "Table No."; Integer)
{
Caption = 'Table No.';
}
field(3; "Table Name"; Text[30])
{
Caption = 'Table Name';
}
field(4; "No. of Records"; Integer)
{
Caption = 'No. of Records';
}
field(5; "Record Size"; Decimal)
{
Caption = 'Record Size';
}
field(6; "Size (KB)"; Integer)
{
Caption = 'Size (KB)';
}
field(7; Compression; Option)
{
Caption = 'Compression';
OptionMembers = None,Row,Page,Columnstore,"Columnstore Archive";
}
field(8; "Data Size (KB)"; Integer)
{
Caption = 'Data Size (KB)';
}
field(9; "Index Size (KB)"; Integer)
{
Caption = 'Index Size (KB)';
}
field(8700; "Last Period Data Size (KB)"; Integer)
{
Caption = 'Last Period Size (30D)';
}
field(8702; "Growth %"; Decimal)
{
Caption = 'Growth % (30D)';
}
field(8701; "Last Period No. of Records"; Integer)
{
Caption = 'Last Period No. of Records (30D)';
}
}
keys
{
key(pk; "Company Name", "Table No.")
{
SumIndexFields = "Size (KB)", "Data Size (KB)", "Index Size (KB)";
}
key(sort; "Data Size (KB)")
{
}
}
}Fields, 12
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Company Name | Text[30] | - |
| 2 | Table No. | Integer | - |
| 3 | Table Name | Text[30] | - |
| 4 | No. of Records | Integer | - |
| 5 | Record Size | Decimal | - |
| 6 | Size (KB) | Integer | - |
| 7 | Compression | Option | - |
| 8 | Data Size (KB) | Integer | - |
| 9 | Index Size (KB) | Integer | - |
| 8700 | Last Period Data Size (KB) | Integer | - |
| 8701 | Last Period No. of Records | Integer | - |
| 8702 | Growth % | Decimal | - |
Keys, 2
| Name | Fields | Obsolete |
|---|---|---|
| pk | Company Name, Table No. | - |
| sort | Data Size (KB) | - |