Table 생성자 (Database, String, String)

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

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Sub New ( _
    database As Database, _
    name As String, _
    schema As String _
)
‘사용 방법
Dim database As Database 
Dim name As String 
Dim schema As String 

Dim instance As New Table(database, _
    name, schema)
public Table(
    Database database,
    string name,
    string schema
)
public:
Table(
    Database^ database, 
    String^ name, 
    String^ schema
)
new : 
        database:Database * 
        name:string * 
        schema:string -> Table
public function Table(
    database : Database, 
    name : String, 
    schema : String
)

매개 변수

  • name
    유형: System.String
    A String value that specifies the name of the schema for the table to be created.
  • schema
    유형: 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")

참고 항목

참조

Table 클래스

Table 오버로드

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

테이블

CREATE TABLE(Transact-SQL)