Monday, January 31, 2011

sys.data_spaces

I've just discovered the use of sys.data_spaces.
This'll give you the data files' information in your database.

use test
go
select * from sys.data_spaces

output:

namedata_space_idtypetype_descis_default
PRIMARY1FGROWS_FILEGROUP1
SQLIndex_22FGROWS_FILEGROUP0
SQLIndex_13FGROWS_FILEGROUP0
SQLData_14FGROWS_FILEGROUP0
SQLData_25FGROWS_FILEGROUP0
SQLData_36FGROWS_FILEGROUP0
SQLData_47FGROWS_FILEGROUP0



No comments:

Post a Comment