Re: Actual Used space
Jacques Renaut wrote:
>
> Wayne Kidd wrote:
> >
> > Does anyone have a query for the SMI tables or any other
> > tables, that will return the actual used space of a table.
> <SNIP>
>
> Try this query against sysmaster:
>
> select tabname, npused from systables, sysptnhdr
> where systabnames.partnum = sysptnhdr.partnum
Er... npused is in systables. I don't have 7.x to hand to look at sysptnhdr, but is it
in there also. If so you will need to qualify the column with the table name. If not
then you don't need sysptnhdr.
Cheers,
--
Mark.
+-------------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| |
|mailto:marks@west.co.za +------------------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work... force it! |
|Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! |
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+------------------------------------------------+