Database.AutoCreateStatisticsEnabled Database.AutoCreateStatisticsEnabled Database.AutoCreateStatisticsEnabled Property

Definition

Gets a value that specifies whether statistics are automatically created for the database.

public:
 property bool AutoCreateStatisticsEnabled { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Deploy)]
public bool AutoCreateStatisticsEnabled { get; set; }
Public Property AutoCreateStatisticsEnabled As Boolean
Property Value

A Boolean value that specifies whether statistics are automatically created for the database.

If True, statistics are automatically created for the database. Otherwise, False (default).

Implements

Examples

VB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display the current options for statistics.  
Console.WriteLine("Automatically create statistics = " + _  
db.AutoCreateStatisticsEnabled.ToString)  
Console.WriteLine("Automatically update statistics = " + _  
db.AutoUpdateStatisticsEnabled.ToString)  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
Write-Host "Automatically create statistics =" $db.AutoCreateStatisticsEnabled  
Write-Host "Automatically update statistics =" $db.AutoUpdateStatisticsEnabled  

Remarks

The AutoCreateStatisticsEnabled property is equivalent to setting the AUTO_CREATE_STATISTICS ON option in the ALTER DATABASE Transact-SQL statement.

Applies to