| 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 | 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 growth is 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. |