Can someone give me query which will give
me the size of individual tables in a database in MB.

rgds

You can get a rough estimate but running either of these in dbaccess, SQL editor, or your favorite SQL tool:

select tabname, ((nrows * rowsize) / 1000000) size
from systables
where tabname = "table_name"

or you could use this:

NOTE: npused is "number of pages used" so you need to know your page size

select tabname, ((npused * your_page_size) / 1000000) size
from systables
where tabname = "table_name"

I prefer to use this one because pages are not 100% filled so there will usually be some unused space per page.

Can u pls let me know how to find the nrows, rowsize
also your_page_size coz im not sure if the one i hav is right.

Rgds,
Anthony.

The values for "nrows" and "rowsize" can be found (for each specific table) in the table called systables for the database you're querying.

You can determine the page size by running onstat -b and looking at the last line of the output. The page size is the same as buffer size which will be either 2048 (2K pages) or 4096 (4K pages).