| title | sys.sysaltfiles (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.sysaltfiles (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 03/15/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server]
Under special circumstances, contains rows corresponding to the files in a database.
Important
[!INCLUDEssnoteCompView]
| 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 | [!INCLUDEssInternalOnly] |
| perf | int | Reserved. |
| 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. |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)