Re: Schema finding in db

Posted in 2006

Jim m — 21 Jul 2006 10:25:12 -0700 — source: Usenet: comp.databases.informix

Samruddhi wrote: > Hi > How to find how many schema's are there in current Informix DB through > SQL Query ? > Thanks in advance > Sam Don't Know what version informix you have. however if you just want to know how many tables you have in a databse you can also use: select tabname, dirpath from systables If you want more info on them just use : select * from systables

↪ replying to Jim m

DL Redden — Fri, 21 Jul 2006 11:16:32 -0700 (PDT) — source: Usenet: comp.databases.informix

I'm inclined to think that this should get you want you want since the idea of a schema is called the table owner in Informix. select distinct owner from systables where tabid > 99 ----- Original Message ---- From: Jim m <jim.murphy@travelinsurance.ca> To: informix-list@iiug.org Sent: Friday, July 21, 2006 12:25:12 PM Subject: Re: Schema finding in db Samruddhi wrote: > Hi > How to find how many schema's are there in current Informix DB through > SQL Query ? > Thanks in advance > Sam Don't Know what version informix you have. however if you just want to know how many tables you have in a databse you can also use: select tabname, dirpath from systables If you want more info on them just use : select * from systables _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list