Re: Get a list of column field names from a MS Access table

On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > On Thu, Feb 26, 2009 at 4:01 PM, revDAVE <Cool@hosting4days.com> wrote: > > > Newbie question: > > > > I would like to get a list of column field names from a MS Access table and > > hopefully get them returned in the ORIGINAL order (as they appear in > > access) > > > > Is there a sql query I could do to get this result? > > > > > > > > > > -- > > Thanks - RevDave > > Cool @ hosting4days . com > > [db-lists 09] > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > A dirty way is to query the table where 1=2 to return no results > > select * from table where 1=2 > That'll just return an empty result set, as in empty and with no fields output! In MySQL you can do this: SELECT column_name FROM information_schema.columns WHERE table_name = 'table_name' this might help with doing the same for M$Access? Ash www.ashleysheridan.co.uk