# 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
```al
CompressionType = None|Page|Row|Unspecified;
```
## Remarks
> NOTE
> The devenv-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<https://learn.microsoft.com/powershell/module/microsoft.dynamics.nav.management/set-navtenant> with the `-Compression` parameter set.
For information about compression types, see Data Compression<../../administration/optimize-sql-data-access#readwrite>.
## Example
The following code snippet sets page-level compression on table 50100.
```al
table 50100 MyTable
{
    TableType = Normal;
    CompressionType = Page;

    fields
    {
       ...
```
## Related information
devenv-properties
../devenv-page-object
Set-NAVTenant cmdlet<https://learn.microsoft.com/powershell/module/microsoft.dynamics.nav.management/get-navtenant>
Start-NAVDataCompression cmdlet<https://learn.microsoft.com/powershell/module/microsoft.dynamics.nav.management/start-navdatabasecompression>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-compressiontype-property, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/properties/devenv-compressiontype-property/
