Export (0) Print
Expand All

sys.data_spaces (Transact-SQL)

Contains a row for each data space. This can be a filegroup, partition scheme, or FILESTREAM data filegroup.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

name

sysname

Name of data space, unique within the database.

data_space_id

int

Data space ID number, unique within the database.

type

char(2)

Data space type:

FG = Filegroup

FD = FILESTREAM data filegroup

FX = Memory-optimized tables filegroup

Applies to: SQL Server 2014 through SQL Server 2014.

PS = Partition scheme

type_desc

nvarchar(60)

Description of data space type:

FILESTREAM_DATA_FILEGROUP

MEMORY_OPTIMIZED_DATA_FILEGROUP

Applies to: SQL Server 2014 through SQL Server 2014.

PARTITION_SCHEME

ROWS_FILEGROUP

is_default

bit

1 = This is the default data space. The default data space is used when a filegroup or partition scheme is not specified in a CREATE TABLE or CREATE INDEX statement.

0 = This is not the default data space.

is_system

bit

1 = Data space is used for full-text index fragments.

0 = Data space is not used for full-text index fragments.

Applies to: SQL Server 2012 through SQL Server 2014.

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft