There is actually a built in stored proceedure for this stuff in MSSQL sp_tables gets all the tables in a database
sp_columns gets all the columns in a table Look up in the sql help on how to use them Steve On May 3, 8:23 am, "AJ Mercer" <[EMAIL PROTECTED]> wrote: > Most databases have tables that store table metadata > like SQL Server has sysobjects > Informix has systables, syscolumns > > You can query these tables to get the information you are after. > What Database Server are you using? > > On 5/3/07, claude raiola <[EMAIL PROTECTED]> wrote: > > > > > > > > > Just wondering if its possible to dynamically read column names of an > > existing sq table. > > > What I am trying to create is a facility where the user can select the > > table name which will then list the columns of the given table. > > > The user can the select the column names of choice which will in turn be > > used to build in a CF Query > > > I look forward to your comments > > > Kind Regards > > > Claude Raiola > > B.Econ(Acc.); B.Hotel Mngt. > > Mobile: 0414 228 948 > > Phone: 07 5527 1990 > > Fax: 07 3319 6444 > > > Websites: > >www.WebsiteSolutions.com.au<http://www.websitesolutions.com.au/> > >www.AustralianAccommodation.com<http://www.australianaccommodation.com/> > >www.AccommodationNewZealand.com<http://www.accommodationnewzealand.com/> > >www.HospitalityPurchasing.net<http://www.hospitalitypurchasing.net/> > >www.Samaris.net<http://www.samaris.net/> > > -- > If you are not living on the edge, > You are taking up too much space.- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
