[AccessD] Select statements to get column definitions?

Martin Reid mwp.reid at qub.ac.uk
Wed May 19 10:17:21 CDT 2004


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
>




More information about the AccessD mailing list