<cfquery name="get" ...>
   show tables
</cfquery>
#get.recordCount#
<cfquery name="get" ...>
   explain #tablename#
</cfquery>
#get.recordCount#

cheers,
barneyb

On 10/28/06, Mike Tangorre <[EMAIL PROTECTED]> wrote:
> Is there a quick way to get the number of tables and columns for a given
> database?
>
> TIA,
>
> Mike
>
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258386
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to