CompressionType Property

Version: Available or changed with runtime version 3.0.

Specifies the compression type used.

Applies to

  • Table

Property value

Value Available or changed with Description
Unspecified runtime version 3.0 Use the compression type that is specified externally on the table, for example, in SQL Server.
None runtime version 3.0 Do not use compression on the table.
Row runtime version 3.0 Compress the table on a row-level.
Page runtime version 3.0 Compress the table on a page-level. This includes row, prefix, and dictionary compression.

Syntax

CompressionType = None|Page|Row|Unspecified; 

Remarks

Note

The TableType property must be Normal. This property cannot be used on table extension objects.

With None, Page, and Row, the Business Central table synchronization process will make changes to table in SQL Server, overwriting the current compression setting in SQL Server, if any. Unspecified lets you control data compression directly on SQL Server or by specifying a database default compression level using the Set-NAVTenant cmdlet with the -Compression parameter set.

For information about compression types, see Data Compression.

Example

The following code snippet sets page-level compression on table 50100.

table 50100 MyTable
{
    TableType = Normal;
    CompressionType = Page;

    fields
    {
       ...

Properties
Page object
Set-NAVTenant cmdlet
Start-NAVDataCompression cmdlet