Re: SQL EXPERTS ONLY
From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1996/07/29
Message-ID: <4tjbgm$bua_at_zimmer.CSUFresno.EDU>#1/1
Date: 1996/07/29
Message-ID: <4tjbgm$bua_at_zimmer.CSUFresno.EDU>#1/1
In article <4tip79$q5u_at_newsbf02.news.aol.com>,
MGreen1962 <mgreen1962_at_aol.com> wrote:
>I need to produce a report that shows how many records are in each table.
>i.e:
>
>Table_Name Number Recs
>----------------------------------------------------------------------
>Employees 413
>Customer 5257
>How can I do this? <snip>
Try:
select 'Table1' "Table",count(*)" Rows " from table1
UNION ALL
select 'Table2' "Table",count(*)" Rows " from table2
UNION ALL ... etc.
HTH
Steve Cosner
Received on Mon Jul 29 1996 - 00:00:00 CEST