Propriété Table.OnlineHeapOperation
Gets or sets the Boolean value that determines whether the table supports online heap or index operations.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Property OnlineHeapOperation As Boolean
Get
Set
'Utilisation
Dim instance As Table
Dim value As Boolean
value = instance.OnlineHeapOperation
instance.OnlineHeapOperation = value
public bool OnlineHeapOperation { get; set; }
public:
property bool OnlineHeapOperation {
bool get ();
void set (bool value);
}
member OnlineHeapOperation : bool with get, set
function get OnlineHeapOperation () : boolean
function set OnlineHeapOperation (value : boolean)
Valeur de propriété
Type : System.Boolean
A Boolean value that specifies whether the table supports online heap or index operations.If True, the table supports online heap operations. Otherwise, False.
Exemples
The following code example lists all of the tables in the AdventureWorks2012 database that support online heap operations.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
foreach (Table tb in db.Tables)
{
if (tb.OnlineHeapOperation == True)
{
Console.WriteLine("The " + tb.Name + " table supports online heap operations.");
}
}
Powershell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
Foreach ($tb in $db.Tables)
{
If ($tb.OnlineHeapOperation -eq $TRUE)
{
Write-Host "The" $tb.Name "table supports online heap operations."
}
}
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo