Re: Schema finding

Posted in 2006

Art S. Kagel — Wed, 19 Jul 2006 10:42:17 -0400 — source: Usenet: comp.databases.informix

Samruddhi wrote: > Richard Harnden wrote: > > >>Samruddhi wrote: >> >>>Hi >>>How to find how many schema's are there in current Informix DB through >>>SQL Query ? >> >>The sysdatabases view in sysmaster lists all the databases. >> >>-- >>rh > > > Hi Richard > I didn't understand what did u suggest me? > Please do write more about the same > thanks > Sam SELECT name as databasename, owner from sysmaster:sysdatabases; Art S. Kagel