共用方式為


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.
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.

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間