On Nov 17, 2007 2:25 PM, Steve Good <[EMAIL PROTECTED]> wrote: > I am drawing a blank here. How do I dump the names of all the tables in > a database and the columns in each of the tables? I know how to dump > the columns and rows from a specified table, but that's not what i want > to do. What I'm trying to do is create a printable database structure > list without the row data. > > Thanks in advance! > ~Steve Good > Coldfusion 8...
<cfdbinfo datasource="dsnName" name="DB" type="tables"> <cfdump var="#db#"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
