If you have access (not sure if this is universal READ or if my db admins just didn't secure this properly) you can do this:
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '$tablename' All the information about the table you'd need should be in there. -TG > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 03, 2004 4:46 PM > To: '[EMAIL PROTECTED]' > Subject: [PHP-WIN] RE: select top 1 * WAS: [PHP-WIN] > [ANNOUNCEMENT] ODBTP 1.1.1 Released > > > Does anybody know if that is faster than doing > SELECT * FROM <some table> WHERE 1 = 2 ? > > -----Original Message----- > From: Gerardo Rojas > To: Robert Twitty; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Sent: 3-6-2004 17:14 > Subject: RE: [PHP-WIN] [ANNOUNCEMENT] ODBTP 1.1.1 Released > > Robert, > > Do you have an example of pulling the Column types from an MS > Sql query? > For example: select top 1 * from mytablename. > > -- > 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
