Table.DisableAllIndexes-Methode

Disables all the indexes that are on the table.

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

Syntax

'Declaration
Public Sub DisableAllIndexes
'Usage
Dim instance As Table

instance.DisableAllIndexes()

public void DisableAllIndexes()

public:
void DisableAllIndexes()

member DisableAllIndexes : unit -> unit

public function DisableAllIndexes()

Hinweise

The table must have been created using the Create() method before the indexes can be disabled.

Beispiele

The following code example shows how to disable all indexes on a table.

C#

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

Table tb = new Table(db, "Test Table");
Column col1 = new Column(tb, "Name", DataType.NChar(50));
Column col2 = new Column(tb, "ID", DataType.Int);

tb.Columns.Add(col1); 
tb.Columns.Add(col2); 
tb.Create();

tb.DisableAllIndexes();
$tb.Drop();

Powershell

#Connect to the local server and get the AdventureWorks2012 database
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

#Create the Table
$tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "Tester Table")
$col1 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "Name", [Microsoft.SqlServer.Management.Smo.DataType]::NChar(50))
$col2 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "ID", [Microsoft.SqlServer.Management.Smo.DataType]::Int)
$tb.Columns.Add($col1)
$tb.Columns.Add($col2)
$tb.Create()

$tb.DisableAllIndexes()
$tb.Drop()

Siehe auch

Verweis

Table Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Tabellen

CREATE TABLE (Transact-SQL)