ShrinkMethod 枚举
The ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public Enumeration ShrinkMethod
用法
Dim instance As ShrinkMethod
public enum ShrinkMethod
public enum class ShrinkMethod
type ShrinkMethod
public enum ShrinkMethod
成员
成员名称 | 说明 | |
---|---|---|
Default | Data in pages located at the end of a file is moved to pages earlier in the file. Files are truncated to reflect allocated space. | |
NoTruncate | Data in pages located at the end of a file is moved to pages earlier in the file. | |
TruncateOnly | Data distribution is not affected. Files are truncated to reflect allocated space, recovering free space at the end of any file. | |
EmptyFile | Migrates all of the data from the referenced file to other files in the same filegroup. (DataFileand LogFile objects only). |