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
<DisplayDescriptionKeyAttribute("Database_AutoCreateStatisticsEnabledDesc")> _
<DisplayNameKeyAttribute("Database_AutoCreateStatisticsEnabledName")> _
Property AutoCreateStatisticsEnabled As Boolean
Get
Set
'Usage
Dim instance As IDatabaseOptions
Dim value As Boolean
value = instance.AutoCreateStatisticsEnabled
instance.AutoCreateStatisticsEnabled = value
[DisplayDescriptionKeyAttribute("Database_AutoCreateStatisticsEnabledDesc")]
[DisplayNameKeyAttribute("Database_AutoCreateStatisticsEnabledName")]
bool AutoCreateStatisticsEnabled { get; set; }
[DisplayDescriptionKeyAttribute(L"Database_AutoCreateStatisticsEnabledDesc")]
[DisplayNameKeyAttribute(L"Database_AutoCreateStatisticsEnabledName")]
property bool AutoCreateStatisticsEnabled {
bool get ();
void set (bool value);
}
[<DisplayDescriptionKeyAttribute("Database_AutoCreateStatisticsEnabledDesc")>]
[<DisplayNameKeyAttribute("Database_AutoCreateStatisticsEnabledName")>]
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.