Export (0) Print
Expand All

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 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.

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.

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft