Re: All table names

But I need only table names... It Would be select name from sysobjects ??? sysobjects.type='U' // means user tables ??? I never worked with oracle. On Thu, 25 Oct 2001 01:10:26 -0400 (EDT) "Andrew M. Yochum" <andrew@digitalpulp.com> wrote: > This should give you a start for Sybase... this will give tables and column metadata: > select > sysobjects.id, > sysobjects.name, > syscolumns.name as colname, > systypes.name as typename, > syscolumns.length, > syscolumns.status > from > sysobjects, > syscolumns, > systypes > where > sysobjects.type = 'U' > and > syscolumns.id = sysobjects.id > and > systypes.usertype = syscolumns.usertype > order by > sysobjects.name, > syscolumns.name > > On Thu, 25 Oct 2001, Tomas V.V.Cox wrote: > > > Joao Prado Maia wrote: > > > > > > On Wed, 24 Oct 2001, Pablo DallOglio wrote: > > > > > > > Anyone knows how do I get all table names of database using Pear::DB ? > > > > > > > > > > Just run a query for 'SHOW TABLES' on MySQL for instance. Every Database > > > has its own way to show this information, so I guess it could be possible > > > to add code on every driver for a 'showTables()' method. > > > > > > I'm not sure if this is desired though. Is PEAR::DB objective to do > > > everything for the user of the class ? If so, this would be a good > > > addition IMO. > > > > > > > Sure, it would be a great contribution. Let's take a look at Metabase or > > ADODB? ;-) > > > > Directly from phplib sources: > > Oracle: SELECT table_name,tablespace_name FROM user_tables > > PostgreSQL: select relname from pg_class where relkind = 'r' and not > > relname like 'pg_%' > > > > > > Tomas V.V.Cox > > > > > > > -- > Andrew Yochum > Digital Pulp, Inc. > 212-679-0676x255 > > > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, e-mail: pear-general-unsubscribe@lists.php.net > For additional commands, e-mail: pear-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Pablo Dall'Oglio Linux User n. 223253