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.
Indicates whether the database files are candidates for periodic shrinking.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<DisplayDescriptionKeyAttribute("Database_AutoShrinkDesc")> _
<DisplayNameKeyAttribute("Database_AutoShrinkName")> _
Property AutoShrink As Boolean
Get
Set
'Usage
Dim instance As IDatabasePerformanceFacet
Dim value As Boolean
value = instance.AutoShrink
instance.AutoShrink = value
[DisplayDescriptionKeyAttribute("Database_AutoShrinkDesc")]
[DisplayNameKeyAttribute("Database_AutoShrinkName")]
bool AutoShrink { get; set; }
[DisplayDescriptionKeyAttribute(L"Database_AutoShrinkDesc")]
[DisplayNameKeyAttribute(L"Database_AutoShrinkName")]
property bool AutoShrink {
bool get ();
void set (bool value);
}
[<DisplayDescriptionKeyAttribute("Database_AutoShrinkDesc")>]
[<DisplayNameKeyAttribute("Database_AutoShrinkName")>]
abstract AutoShrink : bool with get, set
function get AutoShrink () : boolean
function set AutoShrink (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that indicates whether the database files can be shrunk automatically. Returns True if database files can be shrunk automatically; otherwise, False.
Remarks
This property corresponds to the AUTO_SHRINK TSQL argument of ALTER DATABASE SET OPTIONS.
See Also
Reference
IDatabasePerformanceFacet Interface
Microsoft.SqlServer.Management.Smo Namespace