Previous Topic: Define SQL Server Table PropertiesNext Topic: Define SQL Server Table Physical Storage Properties

Creating Models › Creating a Physical Model › Tables › Table Editor › Define SQL Server Table Properties › Specify Data Compression Information for a Table

Specify Data Compression Information for a Table

Use the DataCompression tab to define data compression for tables.

To define data compression options

  1. Open the SQL Server Table Editor for the table for which you want to define data compression options.
  2. Select the table in the Navigation Grid.
  3. Click the DataCompression tab and then click New icon in property editors to create a new object to define new options.
  4. Work with the following options:
    Type

    Specifies the compression type to apply to each partition in the table that you want to compress. For a table, the types are None, Row, and Page.

    Partition Number

    Lists each partition in the table or index.

  5. Click Close.

    The property editor closes.

For more information, refer to SQL Server Documentation.