Table Table Table Constructors

Definition

Overloads

Table() Table() Table()

Initializes a new instance of the Table class.

Table(Database, String) Table(Database, String)

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

Table(Database, String, String) Table(Database, String, String)

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

Table() Table() Table()

Initializes a new instance of the Table class.

public:
 Table();
public Table ();
Public Sub New ()

Remarks

The default constructor initializes any fields to their default values.

Table(Database, String) Table(Database, String)

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

public:
 Table(Microsoft::SqlServer::Management::Smo::Database ^ database, System::String ^ name);
public Table (Microsoft.SqlServer.Management.Smo.Database database, string name);
Parameters
database
Database Database Database

A Database object value that specifies the database in which to create the Table object.

name
String String String

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

Examples

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")  

Table(Database, String, String) Table(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(Microsoft::SqlServer::Management::Smo::Database ^ database, System::String ^ name, System::String ^ schema);
public Table (Microsoft.SqlServer.Management.Smo.Database database, string name, string schema);
Parameters
database
Database Database Database

A Database object value that specifies the database in which to create the Table object.

name
String String String

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

schema
String String String

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

Examples

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")  

Applies to