The ShrinkMethod enumeration contains values that are used to specify the method used shrink a database file.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
语法
声明
Public Enumeration ShrinkMethod
public enum ShrinkMethod
public enum class ShrinkMethod
public enum ShrinkMethod
public enum ShrinkMethod
Members
Member name | Description |
---|---|
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. |
EmptyFile | Migrates all of the data from the referenced file to other files in the same filegroup. (DataFileand LogFile objects only). |
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. |
备注
The ShrinkMethod enumeration class is served by the Shrink method.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
平台
开发平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。
目标平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。