Under special circumstances, contains rows corresponding to the files in a database.
|Applies to: SQL Server (SQL Server 2008 through current version).|
|Column name||Data type||Description|
|fileid||smallint||File identification number. This is unique for each database.|
|groupid||smallint||File group identification number.|
|size||int||File size, in 8-kilobyte (KB) pages.|
|maxsize||int||Maximum file size, in 8-KB pages.|
0 = No growth.
-1 = File will grow until the disk is full.
268435456 = Log file will grow to a maximum size of 2 TB.
Note: Databases that are upgraded with an unlimited log file size will report -1 for the maximum size of the log file.
|growth||int||Growth size of the database.|
0 = No growth. Can be either the number of pages or the percentage of file size, depending on the value of status. If status is 0x100000, growth is the percentage of file size; otherwise, it is the number of pages.
|status||int||Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.|
|dbid||smallint||Database identification number of the database to which this file belongs.|
|name||sysname||Logical name of the file.|
|filename||nvarchar(260)||Name of the physical device. This includes the full path of the file.|