Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to list all Informix database names

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.

like image 443
Anyname Donotcare Avatar asked Dec 22 '22 20:12

Anyname Donotcare


1 Answers

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

select * from sysdatabases 
like image 96
newenglander Avatar answered Apr 08 '23 03:04

newenglander