How to: Create, Alter, and Remove a Database in Visual Basic .NET
This section describes how to add a new database by using Visual Basic.
The code example creates a new database. Files and file groups are automatically created for the database.
-
Start Visual Studio 2005.
-
From the File menu, select New Project. The New Project dialog box appears.
-
In the Project Types pane, select Visual Basic. In the Templates pane, select Console Application.
-
(Optional) In the Name box, type the name of the new application.
-
Click OK to load the Visual Basic console application template.
-
On the Project menu, select Add Reference item. The Add Reference dialog box appears. Select Browse and locate the SMO assemblies in the C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies folder. Select the following files:
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum.dll
Microsoft.SqlServer.SmoEnum.dll
-
On the View menu, click Code.-Or-Select the Module1.vb window to display the code window.
-
In the code, before any declarations, type the following Imports statements to qualify the types in the SMO namespace:
Imports Microsoft.SqlServer.Management.Smo Imports Microsoft.SqlServer.Management.Common
-
Insert the code that follows this procedure into the main program.
-
Run and build the application.
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Define a Database object variable by supplying the server and the database name arguments in the constructor. Dim db As Database db = New Database(srv, "Test_SMO_Database") 'Create the database on the instance of SQL Server. db.Create() 'Reference the database and display the date when it was created. db = srv.Databases("Test_SMO_Database") Console.WriteLine(db.CreateDate) 'Remove the database. db.Drop()
