Arthur Fuller
artful at rogers.com
Sat May 22 10:58:15 CDT 2004
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