Found my answer: exec sp_tables -- Gerardo S. Rojas mailto: grojas@strategicinc.com -----Original Message----- From: Justin Patrin [mailto:papercrane@reversefold.com] Sent: Thursday, December 11, 2003 1:21 PM To: php-windows@lists.php.net Subject: Re: Return all Tables Gerardo Rojas wrote: > I have a connection to an MS SQL server. I am able to get a list of all available DB's on this server by running: > > "exec sp_helpdb" > > the question is: How do we return all tables from a selected db for MS SQL? > > i am developing a web interface to the DB. I need to be able to give my users a choice of which Table to use. > > > -- > Gerardo S. Rojas > mailto: grojas@strategicinc.com > > Not sure about MS SQL, but "show tables;" works in MySql. And "show databases;" works for databases. -- paperCrane <Justin Patrin> -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
