How to list all Informix database names

Question

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.

newenglander · Accepted Answer · 2012-08-29 08:34:46Z

7

Alternatively you could execute this query when connected to the sysmaster database:

select * from sysdatabases

answered Aug 29, 2012 at 8:34

newenglander

2,04924 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

How to get a list of tables for a specific database when connected using sysmaster user?

Rawley Fowler · Accepted Answer · 2024-04-05 19:24:06Z

6

More to the point (years after the question was posed):

select name from sysmaster:sysdatabases;

Rawley Fowler

3,13712 silver badges21 bronze badges

answered May 18, 2015 at 15:17

Jacob Salomon

2992 silver badges7 bronze badges

This is the most precise answer if you want to get the databases listing and works with the most current Informix version (14.1).

Edoardo Pirovano · Accepted Answer · 2010-11-24 15:47:56Z

1

According to the documentation, the command to get a list of the databases on the server you are connected to is simply:

show databases

answered Nov 24, 2010 at 15:47

Edoardo Pirovano

8,3543 gold badges28 silver badges32 bronze badges

This is not working with Informix version 14.1