[MSSQL] sysfiles ...

2000 버전에서의 Sysfiles 정보

Contains one row for each file in a database. This system table is a virtual table; it cannot be updated or modified directly.

Column name	Data type	Description
fileid	smallint	File identification number unique for each database.
groupid	smallint	Filegroup identification number.
size	int	Size of the file (in 8-KB pages).
maxsize	int	Maximum file size (in 8-KB pages). A value of 0 indicates no growth, and a value of -1 indicates that the file should grow until the disk is full.
growth	int	Growth size of the database. A value of 0 indicates no growth. Can be either the number of pages or the percentage of file size, depending on value of status. If status contains 0x100000, then growthis the percentage of file size; otherwise, it is the number of pages.
status	int	Status bits for the growth value in either megabytes (MB) or kilobytes (K). 0x1 = Default device. 0x2 = Disk file. 0x40 = Log device. 0x80 = File has been written to since last backup. 0x4000 = Device created implicitly by the CREATE DATABASE statement. 0x8000 = Device created during database creation. 0x100000 = Growth is in percentage, not pages.
perf	int	Reserved.
name	nchar(128)	Logical name of the file.
filename	nchar(260)	Name of the physical device, including the full path of the file.