Table 8700 Table Information Cache in 24

App
System Application
Namespace
System.DataAdministration

Fields, 12Keys, 2

Versions171819202122232425262728latest

Source242526272829

Source in 24

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

IdNameTypeObsolete
1Company NameText[30]-
2Table No.Integer-
3Table NameText[30]-
4No. of RecordsInteger-
5Record SizeDecimal-
6Size (KB)Integer-
7CompressionOption-
8Data Size (KB)Integer-
9Index Size (KB)Integer-
8700Last Period Data Size (KB)Integer-
8701Last Period No. of RecordsInteger-
8702Growth %Decimal-

Keys, 2

NameFieldsObsolete
pkCompany Name, Table No.-
sortData Size (KB)-