Re: finding the large tables
wasef <mazafar4NOmaSPAM@onebox.com.invalid> wrote:
> In article <85dnmq$m21$1@calais.pt.lu>, "Andrew Pearson"
> <apearson@pt.lu> wrote:
>> Phillip,
>> This is a reasonably straighforward one from the
>> sysmaster
>> database or from systables, if you just want number of
>> rows
>> then try something like:
>> SELECT tabname, nrows
>> FROM systables
>> ORDER BY 2 DESC>> you could also factor in the rowsize.
>> Have a look at deja news and so on, the regular
>> contributors
>> to this newsgroup have written a lot of handy
>> scripts/selects that you could use.
>
> But this shows only the sysmaster tables, what about my
> database???
>
Er no. If you select from the systables table in your desired database
it will show you the tables in your desired database.
/J\\
--
"If homo sapiens really were 'homo' sapiens is that why they're
extinct?" - Joey, Friends