Table.ChangeSchema 方法
Changes the schema on the referenced table.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public Sub ChangeSchema ( _
newSchema As String _
)
用法
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
)
参数
- newSchema
类型:System.String
A String value that specifies the new schema.
注释
The table must be created using the Create method before the schema can be changed.
示例
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")
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间