RE: [PHP-WIN] Return all Tables
| From: | HKG) | Date: | Fri, 12 Dec 2003 07:20:47 +0000 |
| Subject: | RE: [PHP-WIN] Return all Tables | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22369@lists.php.net to get a copy of this message | ||
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: [PHP-WIN] 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