• Article

IDatabaseOptions.AutoCreateStatisticsEnabled Property

Gets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active.

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

Syntax

'Declaration
<DisplayNameKeyAttribute("Database_AutoCreateStatisticsEnabledName")> _
<DisplayDescriptionKeyAttribute("Database_AutoCreateStatisticsEnabledDesc")> _
Property AutoCreateStatisticsEnabled As Boolean
    Get
    Set
'Usage
Dim instance As IDatabaseOptions
Dim value As Boolean

value = instance.AutoCreateStatisticsEnabled

instance.AutoCreateStatisticsEnabled = value

[DisplayNameKeyAttribute("Database_AutoCreateStatisticsEnabledName")]
[DisplayDescriptionKeyAttribute("Database_AutoCreateStatisticsEnabledDesc")]
bool AutoCreateStatisticsEnabled { get; set; }

[DisplayNameKeyAttribute(L"Database_AutoCreateStatisticsEnabledName")]
[DisplayDescriptionKeyAttribute(L"Database_AutoCreateStatisticsEnabledDesc")]
property bool AutoCreateStatisticsEnabled {
    bool get ();
    void set (bool value);
}

[<DisplayNameKeyAttribute("Database_AutoCreateStatisticsEnabledName")>]
[<DisplayDescriptionKeyAttribute("Database_AutoCreateStatisticsEnabledDesc")>]
abstract AutoCreateStatisticsEnabled : bool with get, set

function get AutoCreateStatisticsEnabled () : boolean
function set AutoCreateStatisticsEnabled (value : boolean)

Property Value

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

Remarks

This property specifies whether statistics are automatically created for a database.