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.

See Also