You can do it for Access, but you have to go into access and change the permissions inside to allow changing of the structure... I used to know exactly because I made a tool that showed table structure for Access tables...
When using SQL Server, you can use system stored procedures to do this... On 5/3/05, Knipp, Eric <[EMAIL PROTECTED]> wrote: > > I don't know the answer for this specific to Access, but I can tell you that > in my experience, most databases have system tables which specify schemas > for all tables in the database. From what I've seen each database platform > (and sometimes each version) has its own way of describing this information. > This is where I would start looking. > > Good luck, > > Eric > > > -----Original Message----- > From: Ron Mast [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 03, 2005 9:43 AM > To: [email protected] > Subject: displaying tablenames > > > > > Hi All, > > Is there a way to display all the tables in an access database, or any > database in CF? Thanks in advance. > > > > Ron Mast > > Webmaster > > Truth Hardware > > Ph: 507-444-4748 > > Fx: 507-444-5361 > > www.truth.com > > > > _______________________________ > > This e-mail and any files transmitted with it are confidential and are > intended solely for the use of the individual to whom they are addressed. > If you are not the intended recipient or the individual responsible for > delivering the e-mail to the intended recipient, please be advised that you > have received this e-mail in error and that any use, dissemination, > forwarding, printing, or copying of this e-mail is strictly prohibited. > > ________________________________ > > > > > CONFIDENTIALITY NOTICE: The information contained in this e-mail and > attached document(s) may contain confidential information that is intended > only for the addressee(s). If you are not the intended recipient, you are > hereby advised that any disclosure, copying, distribution or the taking of > any action in reliance upon the information is prohibited. If you have > received this e-mail in error, please immediately notify the sender and > delete it from your system. -- My Blog http://www.clinttredway.com Are you diabetic? http://www.diabetesforums.com ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
