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
Reference
Data Spaces and Full-Text Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.databases (Transact-SQL)
sys.destination_data_spaces (Transact-SQL)
sys.filegroups (Transact-SQL)
sys.partition_schemes (Transact-SQL)
Other Resources
Querying the SQL Server System Catalog FAQ