Database.AutoShrink Property

Gets or sets a value that specifies whether the AUTO_SHRINK database option is active.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property AutoShrink As Boolean 
    Get 
    Set
'Usage
Dim instance As Database 
Dim value As Boolean 

value = instance.AutoShrink

instance.AutoShrink = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)]
public bool AutoShrink { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Deploy)]
public:
virtual property bool AutoShrink {
    bool get () sealed;
    void set (bool value) sealed;
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
abstract AutoShrink : bool with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
override AutoShrink : bool with get, set

final function get AutoShrink () : boolean 
final function set AutoShrink (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the AutoShrink database option is active. If True, the database is automatically reduced. If False (default), statistics are not automatically reduced.

Implements

IDatabaseOptions.AutoShrink

See Also

Reference

Database Class

Microsoft.SqlServer.Management.Smo Namespace