开发者

How to list all Informix database names

开发者 https://www.devze.com 2023-01-26 23:11 出处:网络
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

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
0

精彩评论

暂无评论...
验证码 换一张
取 消