Subject Re: [firebird-support] SHOW DATABASES Equivalent
Author Helen Borrie
At 06:36 PM 17/11/2008, you wrote:
>Hi all,
>I'm sure I've asked this before, but I can't for the life of me remember the syntax.
>I need the firebird equivalent, if there is one, of the MySQL SHOW DATABASES to return a result set which is a list of databases.

There is no such thing. Many of the third-party tools allow you to "register" a database and will provide some way for you to list the registered databases. Those applications use their own mechanism for storing that information (ini files, conf files, maybe Registry entries, if it's on Windows).

Firebird itself has no way to know whether a file is a database until it actually tries to connect to it...and it won't be able to do that unless someone or something gives it a path to a database file.

./heLen