Bobby Heid
bheid at appdevgrp.com
Wed May 19 10:20:55 CDT 2004
Wouldn't that be 'That would create a field called SomeOtherName' instead of 'That would create a field called MyField'? Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Wednesday, May 19, 2004 11:13 AM To: accessd at databaseadvisors.com 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