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.

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

PS = Partition scheme

FD = FILESTREAM data filegroup

type_desc

nvarchar(60)

Description of data space type:

ROWS_FILEGROUP

PARTITION_SCHEME

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

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