Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Enumeration ShrinkMethod
'Usage
Dim instance As ShrinkMethod
public enum ShrinkMethod
public enum class ShrinkMethod
type 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. |
Remarks
The ShrinkMethod enumeration class is served by the Shrink method.