Listing databases |
[This is preliminary documentation and is subject to change.]
How to list databases created on a server
Use this procedure to query the database server. The result is a list of databases created on this server.
![]() |
---|
This list will display all databases on the server, i.e. it will also show databases that are NOT built for any TOPICA application. |
Open a command prompt and navigate to the folder containing the command scripts. In this command prompt, enter the command ListDatabases (with no parameters). The command prompt will display:
ListDatabases - list databases Missing parameter(s) - expected: Server Username Password Server: Servername (use "." or "localhost" for current machine). Username: Login. For trusted connection (= Windows authentication): use "*". Password: Password. For trusted connection (= Windows authentication): use "*".
Examples:
ListDatabases MyServer sa sapassw
List databases created on server "MyServer" using SQL Server login "sa" and password "sapassw".
ListDatabases MyServer * *
List databases created on server "MyServer" using Windows authentication.