Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Table Constructor

 

Applies To: SQL Server 2016 Preview

Initializes a new instance of the Table class.

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

NameDescription
System_CAPS_pubmethodTable()

Initializes a new instance of the Table class.

System_CAPS_pubmethodTable(Database, String)

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

System_CAPS_pubmethodTable(Database, String, String)

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

Return to top

Table Constructor ()

Initializes a new instance of the Table class.

public Table()

The default constructor initializes any fields to their default values.

Return to top

Table Constructor (Database, String)

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

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

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

Legacy Code Example

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")
Return to top

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.

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.

Legacy Code Example

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:
© 2015 Microsoft