EnumFiles Method (Database)
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The EnumFiles method returns a QueryResults object that enumerates the operating system files used to implement Microsoft SQL Server database storage.
語法
object
.EnumFiles( )
as
QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT EnumFiles(
LPSQLDMOQUERYRESULTS* ppResults);
Returns
A QueryResults object that contains one result set defined by these columns.
Column |
Data type |
Description |
|---|---|---|
fileid |
smallint |
System-generated identifier of the operating system file. |
filename |
nchar(261) |
Operating system name of the file. |
groupid |
smallint |
System-generated identifier of the filegroup that contains the operating system file. 0 for files implementing transaction log storage. |
growth |
integer |
Growth factor. When file grows by a fixed percentage, the value is the percentage multiplied by 100. When the file grows by a fixed size increment, the increment is expressed as a number of pages. |
maxsize |
integer |
Maximum size if set, -1 if no maximum specified. |
name |
nchar(129) |
Logical name of the operating system file. |
perf |
integer |
Reserved. |
size |
integer |
Size of the file expressed as number of pages contained. For an instance of SQL Server version 7.0, a page is 8,192 bytes. |
status |
integer |
Bit-packed flag value that indicates creation or other attributes as described in Remarks. |
備註
The status column of the returned result set is a bit-packed value. Interpret the status column using these values.
Value |
Description |
|---|---|
1 |
Reserved. |
2 |
Operating system file maintains database data. |
64 |
Operating system file maintains transaction log records. |
128 |
Operating system file has been written to after the most recent backup. |
16384 |
Operating system file implicitly created as part of database creation or alteration. |
32768 |
Operating system file explicitly created as part of database creation or alteration. |
1048576 |
File growth value is interpreted as a percentage. |