create database, which parameter

[luccingolo]

Hi all I'm experiencing troubles with the code from this site. Which parameter is exspected instead of:"master..sysdatabases" in the following sql-command:Dim mySQL As String = _ "IF EXISTS (" & _ "SELECT * " & _ "FROM master..sysdatabases " & _ "WHERE Name = 'MyDatabase')" & vbCrLf & _ "DROP DATABASE MyDatabase " & vbCrLf & _ "CREATE DATABASE MyDatabase " Thanks, Lucchingolo

[Corporal Agarn]

What database engine are you using?

[luccingolo]

I'm using Microsoft SQL Server 2008

[Corporal Agarn]

Okay, by right clicking on a database in SSMS you can select "Script Database as" then select "DROP to" you can then find that you are looking for sys.databases As this looks like .NET code you may not have access to SSMS so here is an T-SQL example:

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDatabase')
DROP DATABASE [MyDatabase]

[luccingolo]

Sorry, still get an error. Maybe i misundertood you. Fact is that i still get an error. What i did is using your sql-command as string for my SQL-command. What I mean is this: In the Form1_Load-Event of my Application(project). MyConnection = "Server=localhost;" & "DataBase=;" & "Integrated Security=SSPI" 'Your line of code Dim mySQL As String = "IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDatabase')DROP DATABASE [MyDatabase]" Try Dim conn As New SqlConnection(MyConnection) Dim myCmd As New SqlCommand(mySQL, conn) conn.Open() myCmd.ExecuteNonQuery() conn.Close() . . . Last but not least, don't forget that the point is not only to "drop" a Database but i'm trying so hard to create a SQL-Database. :) thank you, Lucchingolo

[Corporal Agarn]

You will need a semicolon before the drop. If you are not dropping a database I would suggest not even coding the if - drop. I have not programmed this at the .NET end. You may need to go to the VS forum.

[luccingolo]

Thank your, I will give it a try in the Visual Basic forum. I could not find a VS-forum. Guess you meant the VB-forum.