Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Table Constructor (Database, String)

Table Constructor (Database, String)

Initializes a new instance of the Table class on the specified database and that has the specified name.

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

public Table(
	Database database,
	string name
)

Parameters

database
Type: Microsoft.SqlServer.Management.Smo.Database
A Database object value that specifies the database in which to create the Table object.
name
Type: String
A String value that specifies the name of the table to be created.

The following code example shows how to declare a new table on the specified database, with the specified name.

C#

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

Table tb = new Table(db, "Test Table");

Powershell

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

#Define the Table
$tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "Test Table")

Community Additions

ADD
Show:
© 2015 Microsoft