Question What is the SQL syntax to check if there's a database or not?

[capedech]

Hi,
I want to ask, What is the SQL syntax to check if there's a database or not?
I'm making an application using MySQL as the database.
In the splashscreen, I want to make a validation to check if there's a database or not, so that I can make the database programmaticaly if it doesn't have the database.

I am thinking using Try Catch, but I don't know what is the SQL Syntax.

Thanks in Advance.

Regards,

 

[ggunter]

I'm not sure there is a Sql statement for that.

I would use the File.Exist method in System.IO.

 

[Alarion]

For MySQL only:

make sure you are connected to the "mysql" database.

You can obtain a list of databases for the server using the following query:

SELECT Db FROM db