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:B.A.T.Svensson@xxxxxxx] > Sent: Thursday, June 03, 2004 4:46 PM > To: 'php-windows@xxxxxxxxxxxxx' > Subject: 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; php-db@xxxxxxxxxxxxx; php-windows@xxxxxxxxxxxxx > Sent: 3-6-2004 17:14 > Subject: RE: [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
