RE: [PHP-DB] Viewing the DB

This was taken from one of the doc's on IBM's site: SYSTABLES contains a row for every table and view in the SQL collection. It tells you if the object is a table or view, the object name, the owner of the object, what SQL collection it is in, and so forth. The following sample statement displays information for the CORPDATA.DEPARTMENT table: SELECT * FROM CORPDATA.SYSTABLES WHERE NAME = 'DEPARTMENT' so a "select * from <schema>.systables" should get you a list of all table names (theoretically) ;P Sean -----Original Message----- From: Scott Fletcher [SMTP:scott@abcoa.com] Sent: Wednesday, January 24, 2001 3:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Viewing the DB I'm using IBM DB2. No Oracle, No mySQL. Scott ""Scott Fletcher"" <scott@abcoa.com> wrote in message news:94mt56$skf$1@toye.p.sourceforge.net... > Does anyone know what is the sql command that would allow me to view all of > the tables in the database? > > Scott > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net