• Article

Table Properties (Storage Page)

Displays the storage related properties of the selected table. Use the CREATE TABLE and ALTER TABLE statements to create and modify compression, filegroup, and partition settings. To change the compression properties, use the Data Compression Wizard F1 Help.

Compression

  • Compression type
    The compression type of the table. This property is only available for tables that are not partitioned.

  • Partitions using page compression
    The partition numbers that are using page compression. This property is only available for partitioned tables.

  • Partitions not compressed
    The partition numbers that are not compressed. This property is only available for partitioned tables.

  • Partitions using row compression
    The partition numbers that are using row compression. This property is only available for partitioned tables.

Filegroup

  • Text filegroup
    The name of the filegroup that contains the text data for the table.

  • Filestream filegroup
    Specify the name of the FILESTREAM data filegroup if the table has a varbinary(max) column that has the FILESTREAM attribute. The default value is the default FILESTREAM data filegroup.

    If the table does not contain FILESTREAM data, the field is blank.

  • Filegroup
    The name of the filegroup that contains the table.

  • Table is partitioned
    Possible values are True and False.

General

  • Vardecimal storage format is enabled
    When True, this read-only value indicates that decimal and numeric data types are stored by using the vardecimal storage format. To change this option, use the vardecimal storage format option of sp_tableoption. For information about vardecimal storage format, see Storing Decimal Data As Variable Length. Vardecimal storage format is available only in SQL Server 2005 and later versions, in the Enterprise, Developer and Evaluation editions. In SQL Server 2008 and later versions, vardecimal storage format is deprecated. Use ROW compression instead. For more information, see Creating Compressed Tables and Indexes.

  • Row count
    The number of rows in the table.

  • Index space
    The amount of space in megabytes that the indexes occupy in the table. This value does not include XML index space usage for the table. If XML indexes belong to the table, use sp_spaceused instead.

  • Data space
    The amount of space in megabytes that the data occupies in the table.

Partitioning

This section is only available if the table is partitioned.

  • Partition column
    The name of the column on which the table is partitioned.

  • Partition scheme
    Name of the partition scheme if the table is partitioned. If the table is not partitioned, the field is blank.

  • Number of partitions
    The number of partitions in the table.

  • FILESTREAM partition scheme
    The name of the FILESTREAM partition scheme if the table is partitioned. If the table is not partitioned, the field is blank.

    The FILESTREAM partition scheme must be symmetric to the scheme that is specified in the Partition scheme option.