RE: [PHP-WIN] Re: Return all Tables
| From: | Gerardo Rojas | Date: | Thu, 11 Dec 2003 20:12:08 +0000 |
| Subject: | RE: [PHP-WIN] Re: Return all Tables | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22368@lists.php.net to get a copy of this message | ||
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: [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: 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