Table Editor tab - Storage

On the Storage tab, you can configure storage settings that define where and how the data for the table is stored.

Table Editor - Storage

Storage settings

The table describes storage settings from the left panel.

Name Description
Regular data space Specifies the filegroup where the main table data will be physically stored.
To update a list of filegroups, click Refresh icon Refresh.
Note: PRIMARY is the default filegroup created with the database unless otherwise specified.
Shortcut: Ctrl+R
Partition column Defines a column that splits the data in multiple partitions, each stored in a different filegroup.
When the setting is disabled, partitioning is not configured for this table.
Filestream data space Defines where SQL Server will store FILESTREAM-enabled columns.
When it is set to <Default>, it implies that FILESTREAM data (binary large objects, such as documents or images) will use the default storage settings.
To update a list of filegroups, click Refresh icon Refresh.
Shortcut: Ctrl+R
Text/Image filegroup Controls where to store TEXT, NTEXT, or IMAGE data types.

To update a list of filegroups, click Refresh icon Refresh.
Shortcut: Ctrl+R

The table describes storage settings of a partition table from the right panel.

Name Description
Partition number Shows the number of partitions the table has.
Compression type Defines whether row/page compression is applied.
The available types are:
  • NONE – No row/page compression is applied.
  • ROW – Row compression is applied.
  • PAGE – Page compression is applied.
Filegroup Indicates a filegroup that stores data for this partition.

Save the changes

An asterisk ( * ) on the table editor tab title indicates that there are unsaved changes.

To save and apply them, on the Table Editor toolbar, select Apply Changes.

Note

Use Ctrl+F to locate column definitions or table settings in the DDL script.