[AccessD] Select statements to get column definitions?

Arthur Fuller artful at rogers.com
Thu May 20 19:11:23 CDT 2004


Exactly. I want to specify a table name and get back the list of fields,
datatypes and field descriptions.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, May 19, 2004 11:17 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Select statements to get column definitions?


Is it the system table information you are after?? For example Select
fieldname,datatype,description , indexes from some system table?



Martin


----- Original Message ----- 
From: <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, May 19, 2004 4:12 PM
Subject: RE: [AccessD] Select statements to get column definitions?


> As far as I know, the only 'options' you have with a SELECT statement 
> is
the
> AS keyword.  ie, you can say SELECT MyField AS SomeOtherName FROM 
> tblMyTable.  That would create a field called MyField, which would be 
> the 'caption' of a field.  Not sure what you are actually trying to do

> though, so if you explain what you are trying to accomplish, I may be 
> able to help
a
> little more.
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur 
> Fuller
> Sent: Wednesday, May 19, 2004 10:01 AM
> To: AccessD
> Subject: [AccessD] Select statements to get column definitions?
>
>
> Is there a way to write a SELECT statement so that its result looks 
> similar to the display you see when you design a table? That is, 
> column name, type and description -- I don't care about the other 
> attributes at the moment. I know you can use the Documenter but I want

> the results as a table if possible.
>
> TIA,
> Arthur
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list