This topic has not yet been rated - Rate this topic

sys.data_spaces (Transact-SQL)

SQL Server 2008

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions