Re: How to find which tables are populated with data
In article <64vfh2$2up@cssun.mathcs.emory.edu>, davidmc@sei.co.uk says...
>
>Hello
>I need a little help as I'm very new to the DBA game!!!!
>
>Is there a sql statement by which I can select tables on a particular
>database to see if they are populated with data ?
>
>I've tried
>select * from systabnames
> where dbsname = 'testdb'>
If you run an "update statistics" over all the tables you may select nrows from
systables in the testdb database.
if not ... you may work with the sysmaster database or use the oncheck utility
that reports (oncheck -pt ).
regards