开发者

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.


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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜