Método Table.DisableAllIndexes
Disables all the indexes that are on the table.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Sub DisableAllIndexes
'Uso
Dim instance As Table
instance.DisableAllIndexes()
public void DisableAllIndexes()
public:
void DisableAllIndexes()
member DisableAllIndexes : unit -> unit
public function DisableAllIndexes()
Comentários
The table must have been created using the Create() method before the indexes can be disabled.
Exemplos
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()
Consulte também
Referência
Namespace Microsoft.SqlServer.Management.Smo