Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to list all Informix database names

Tags:

database

informix

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
Sign in to Comment

Related questions

Which approach is better in LINQ?
Firestore - Difference between QueryReferences and Snapshot?
Mongoosejs .find returning whole model instead of document [duplicate]
Unable to run 'USING PERIODIC COMMIT' since last week on NEO4J
Is there a way to get types/names of an unknown db query without executing it?
What is easiest way to transfer tables between MSSQL databases without a network connection?
Where to do joins - in the database server or in the application server?
Is it recommended practice to use uniform extent sizes in Oracle tablespaces?
Storing Data as XML
Android. How to protect your database?
Fastest method to fill a database table with 10 Million rows
Oracle -- Import data into a table with a different name?
Why does JDBC driver pad some blank characterS other a queried field, from an Oracle Database?
Terribly slow SQL query with COUNT and GROUP BY on two columns
Python daemon to watch a folder and update a database
Django -- How to filter objects with an "author" from a set of "authors"(users)?
What is wrong with this database query?
general things developer must know having 2+ years of exp?
Database: Multiple tables or just one table?
How do you avoid this race condition in Python / Django / MySQL?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!