Getting a Database List

I need to know the interactive SQL syntax to get a listing of databases on the current server.

Using Informix, the commands would be:
database sysmaster;
select name from sysdatabases;

MySQL:
show databases;

MS-SQL:
SELECT name FROM master..sysdatabases ORDER BY name

Please reply by posting to this newsgroup. My email address is hashed to protect me from spamming.

Thanks,
Lee Received on Thu Jul 25 2002 - 04:54:15 CEST