Table Constructor (Database, String, String)

Table Constructor (Database, String, String)

 

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

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

public Table(
	Database database,
	string name,
	string schema
)

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: System.String

A String value that specifies the name of the schema for the table to be created.

schema
Type: System.String

A String value that specifies the name of the schema for 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", "Public");

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", "Public")
Return to top
Show:
© 2016 Microsoft