php-windows Digest 12 Dec 2003 12:18:25 -0000 Issue 2038
Topics (messages 22368 through 22370):
Re: Return all Tables
22368 by: Gerardo Rojas
22369 by: Svensson, B.A.T. (HKG)
need back up .......
22370 by: toby z
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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
--- End Message ---
--- Begin 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
hay guyz ....
this is a rather quick one .....
are these two releases stable ????
php 4.3.++ what ever n apache 2 ?????
how many buggz have you guyz encountered so far ?????
what kind .... briefly plz ....
i guess i just got ma self in a bit of a querrel with ma god-fo-saken
boss here .....
n i need backup ......
i would really appriciate any kind of it .....
thnx guyz .....
toby :)
________________________________________________________________________
BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st
December 2003. The way the internet was meant to be.
http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk
--- End Message ---
