Re: All table names

Now I still need to know table names on: FrontBase InterBase mssql msql On Thu, 25 Oct 2001 09:39:22 -0400 (EDT) "Andrew M. Yochum" <andrew@digitalpulp.com> wrote: > Yes. Type has a variety of possible values... These are the ones you might > be insterested in: > > 'S': System Table > 'U': User table > 'V': View > > So: select name from sysobjects where type = 'U' > is what you want. > > And... the same query should also work for MS SQL Server. > > > > On Thu, 25 Oct 2001, Pablo DallOglio wrote: > > > &excuse me, change oracle by sybase > > > > On Thu, 25 Oct 2001 09:14:08 -0300 > > Pablo DallOglio <pablo@univates.br> wrote: > > > > > 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 > > > > > > -- > > > 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 > > > > > > > > -- > Andrew Yochum > Digital Pulp, Inc. > 212.679.0676x255 > andrew@digitalpulp.com > > > -- > 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