SELECT name FROM sysobjects WHERE type = <table> AND <the db user ID equal should be checked to> Can't recall the values now since I write this at home. I can find out later on today however... -----Original Message----- From: Gerardo Rojas To: php-windows@lists.php.net Sent: 2003-12-11 20:04 Subject: Return all Tables 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
