Any way to get number of rows in each table? That would be REALLY useful ....
-----Original Message----- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 <cfset MyDSN = "YourDSN"> <cfdbinfo type="tables" datasource="#MyDSN#" name="tableMetaData" > <table> <cfoutput query="tableMetaData"> <cfdbinfo type="columns" datasource="#MyDSN#" name="ColumnMetaData" table = "#TABLE_NAME#" > <tr> <td><strong>#TABLE_NAME#</strong></td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <cfloop query="ColumnMetaData"> <tr> <td>#COLUMN_NAME#</td> <td>#TYPE_NAME# </td> <td>#COLUMN_SIZE#</td> <td>#IS_PRIMARYKEY#</td> <td>#COLUMN_DEFAULT_VALUE#</td> </tr> </cfloop> </cfoutput> </table> On Fri, Apr 25, 2008 at 4:43 PM, Steve Good <[EMAIL PROTECTED]> wrote: > I did this once before, but forgot how I did it, and can't figure out how > I > found the answer either. > > > > Do any of you know how I can print all the table names, columns in the > tables, and data types of the columns from within MS SQL Server Mgmnt > Studio? > > > > Thanks. > > > > ~Steve > > http://lanctr.com/ > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
