Re: Get a list of column field names from a MS Access table
| From: | Paul M Foster | Date: | Sat, 28 Feb 2009 23:08:41 +0000 |
| Subject: | Re: Get a list of column field names from a MS Access table | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-288992@lists.php.net to get a copy of this message | ||
On Sat, Feb 28, 2009 at 12:41:12AM +0000, Ashley Sheridan wrote:
> On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote:
<snip>
> 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?
>
This is the SQL standard way of doing this. Both MySQL and PostgreSQL
support it. Don't know about MSSQL.
Paul
--
Paul M. Foster