This will get you what you want. SELECT * FROM INFORMATION_SCHEMA.Columns WHERE table_name = 'your_table'
On Mon, Mar 30, 2009 at 10:11 AM, BobSharp <[email protected]> wrote: > > Thanks, but the CFC is a bit beyond me at the moment. > > How would I insert it in a CFM page ? > > > > > ----- Original Message ----- > From: "Gerald Guido" <[email protected]> > To: "cf-talk" <[email protected]> > Sent: Monday, March 30, 2009 2:25 PM > Subject: Re: Finding schema details with CF 6.1 ? > > > > > > Sorry about that.... I had my coffee now... I wrote a query to do that a > > while back. I can't find it now. :-( > > > > Brian Rinaldi has a CFC in his CFC generator (Illudium) project that > will > > tease this out for you. > > > > > http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/model/datasource/mysql.cfc > > > > There are other cfc's in there for other DB's > > > > > http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/model/datasource/ > > > > HTH > > > > G! > > > > > > On Mon, Mar 30, 2009 at 9:19 AM, BobSharp <[email protected]> wrote: > > > >> > >> MySQL > >> > >> See previous posts in this thread. > >> > >> I have done it for a list of Tables, now need to > >> extract FULL details of individual Tables. > >> > >> > >> > >> > >> ----- Original Message ----- > >> From: "Gerald Guido" <[email protected]> > >> To: "cf-talk" <[email protected]> > >> Sent: Monday, March 30, 2009 1:55 PM > >> Subject: Re: Finding schema details with CF 6.1 ? > >> > >> > >> > > >> > What database are you using? There are different dialects on how to > >> tease > >> > that out. I would take a look at sql.cfc for the MSSQL . I have the > >> > sql > >> > for > >> > MySQL some where in my archive if you need it.. > >> > > >> > > >> > H! > >> > > >> > On Mon, Mar 30, 2009 at 6:57 AM, BobSharp <[email protected]> > >> > wrote: > >> > > >> >> > >> >> Can I use CF 6.1 (including hot fixes) > >> >> to see what tables are in the schema ? > >> >> > >> >> > >> >> > >> >> > >> >> -- > >> >> I am using the free version of SPAMfighter. > >> >> We are a community of 6 million users fighting spam. > >> >> SPAMfighter has removed 12840 of my spam emails to date. > >> >> Get the free SPAMfighter here: http://www.spamfighter.com/len > >> >> > >> >> The Professional version does not have this message > >> >> > >> >> > >> >> > >> >> > >> > > >> > > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
