[AccessD] Select statements to get column definitions?

Sorry I know what it is you want to do but dont know excatly how to do it.

I have sent your question to the individal I told you about. Asked him to
respond directly to you.

Martin


----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Saturday, May 22, 2004 4:58 PM
Subject: RE: [AccessD] Select statements to get column definitions?


> Nobody but you has responded to this thread, sadly, and only with a
> question not with an answer. Oh well. In SQL Server the answer is
> obvious. Everything I want is available in the SysColumns table. Where
> is the same info in an MDB?
>
> Maybe I should just upsize the database and then run the SELECT?
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Thursday, May 20, 2004 8:11 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] Select statements to get column definitions?
>
>
> 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
>
> -- 
> _______________________________________________
> 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
>