Re: meta data structure where?

Posted in 2004

Mark D. Stock — Thu, 15 Jan 2004 22:47:22 +0000 — source: Usenet: comp.databases.informix

Ph. Chantry wrote: >>=> a view or table that list all tables for my database. > > > Each database contains one table called systables. > > "select tabname from systables" gives you the name of all the tables > > "select tabname from systables where tabid > 99" gives you the name of all > the tables other than system tables (i.e. the tables that have been created > by some user). It also gives you all the views, synonyms, etc. created by users. You need to add: AND tabtype = "T" for tables only. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list