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:321097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
