| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sysaltfiles (Transact-SQL) |
sys.sysaltfiles (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
[!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)