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

On Fri, Feb 27, 2009 at 7:41 PM, Ashley Sheridan <ash@ashleysheridan.co.uk> wrote: > 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 > I haven't ever seen information_schema in M$ Access. Andrew