MartyConnelly
martyconnelly at shaw.ca
Sat May 22 12:50:25 CDT 2004
It is all available through ADOX schemas. I may have some code lying around Arthur Fuller wrote: >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 >> >> >> > > > -- Marty Connelly Victoria, B.C. Canada