I want to know if there is any 开发者_开发问答way to list (get) all the database names on Informix. I need a proper query or stored procedure to do that.
Alternatively you could execute this query when connected to the sysmaster
database:
select * from sysdatabases
More to the point (years after the question was posed):
select name from sysmaster:sysdatabases;
According to the documentation, the command to get a list of the databases on the server you are connected to is simply:
show databases
精彩评论