SELECT
so.name as tableName
,MAX(SIX.rows) as rowCounter
FROM sysobjects SO INNER JOIN sysindexes SIX ON SIX.id = OBJECT_ID(SO.name)
WHERE SO.xtype = 'U'
GROUP BY SO.name
ORDER BY 2 DESC
On Fri, Apr 25, 2008 at 7:11 PM, Colman, Richard <[EMAIL PROTECTED]>
wrote:
> 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:304280
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
