Database Constructor (Server, String)
Collapse the table of content
Expand the table of content

Database Constructor (Server, String)

 

Initializes a new instance of the Database class on the specified server and with the specified name.

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

public Database(
	Server server,
	string name
)

Parameters

server
Type: Microsoft.SqlServer.Management.Smo.Server

A Server object that represents the instance of SQL Server on which the database exists.

name
Type: System.String

A String value that specifies the name of the database.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database($srv, "Test_SMO_Database")
$db.Create()
Write-Host $db.CreateDate
$db.Drop()
Return to top
Show:
© 2016 Microsoft