Table.ChangeSchema-Methode

Changes the schema on the referenced table.

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

Syntax

'Declaration
Public Sub ChangeSchema ( _
    newSchema As String _
)
'Usage
Dim instance As Table 
Dim newSchema As String

instance.ChangeSchema(newSchema)

public void ChangeSchema(
    string newSchema
)

public:
void ChangeSchema(
    String^ newSchema
)

member ChangeSchema : 
        newSchema:string -> unit

public function ChangeSchema(
    newSchema : String
)

Parameter

• newSchema
  Typ: System.String
  A String value that specifies the new schema.

Hinweise

The table must be created using the Create method before the schema can be changed.

Beispiele

The following code example shows how to change the schema of 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.ChangeSchema("Person");

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

$tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "Test 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.ChangeSchema("Person")

Siehe auch

Verweis

Table Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Tabellen

CREATE TABLE (Transact-SQL)