Table Designer tab - Storage

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

Storage detail panels

The following table describes the storage settings in the left panel.

Name	Description
Regular data space	Specifies the filegroup where the main table data is physically stored. To update the list of filegroups, click . 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 into multiple partitions, each stored in a different filegroup. When the setting is turned off, partitioning is not configured for this table.
Filestream data space	Defines where SQL Server will store FILESTREAM-enabled columns. When set to <Default>, FILESTREAM data uses the default storage settings. To update the list of filegroups, click . Shortcut: Ctrl+R
Text/Image filegroup	Controls where to store TEXT, NTEXT, or IMAGE data types. To update the list of filegroups, click . Shortcut: Ctrl+R

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

Name	Description
Partition number	Displays the number of partitions the table has.
Compression type	Defines whether row or page compression is applied. Available values are: NONE – No row or page compression is applied. ROW – Row compression is applied. PAGE – Page compression is applied.
Filegroup	Indicates the filegroup that stores data for this partition.

Save the changes

An asterisk (*) on the Table Designer tab indicates that there are unsaved changes.

To save and apply them, in the bottom panel, select Apply Changes.

Note

To discard all changes made since Table Designer was opened or last saved, on the standard toolbar, click . The object is reloaded from the server, and all unsaved changes are permanently lost. You can’t redo changes after an undo operation for database objects.