Found my answer: exec sp_tables
-- Gerardo S. Rojas mailto: [EMAIL PROTECTED] -----Original Message----- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:21 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] 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: [EMAIL PROTECTED] > > 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
