• Article

DatabaseOptions.AutoCreateStatistics 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
<SfcPropertyAttribute> _
Public Property AutoCreateStatistics As Boolean
    Get
    Set
'Usage
Dim instance As DatabaseOptions
Dim value As Boolean

value = instance.AutoCreateStatistics

instance.AutoCreateStatistics = value

[SfcPropertyAttribute]
public bool AutoCreateStatistics { get; set; }

[SfcPropertyAttribute]
public:
property bool AutoCreateStatistics {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute>]
member AutoCreateStatistics : bool with get, set

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

Property Value

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

Remarks

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