Export (0) Print
Expand All

sys.data_spaces (Transact-SQL)

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

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

type

char(2)

Data space type:

FG = Filegroup

PS = Partition scheme

type_desc

nvarchar(60)

Description of data space type:

ROWS_FILEGROUP

PARTITION_SCHEME

is_default

bit

1 = This is the default data space. This 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.

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

Community Additions

ADD
Show:
© 2014 Microsoft