Num_Rows * Row_Size + table headers in file 1.
Albert
On 11/27/2013 10:26 PM, Mohammed Sattar wrote:
Hi Bill
Actually I was wanting to know the Size of the table like how many KB ?
Mohammed Sattar
Utah Group of Companies
*From:*[email protected] [mailto:[email protected]] *On Behalf Of
*Bill Downall
*Sent:* Wednesday, November 27, 2013 5:57 PM
*To:* RBASE-L Mailing List
*Subject:* [RBASE-L] - Re: knowing the size of a Table
Mohammed,
Here's a query that will give you some statistics about a table. Name
it TableStats.rmd and run it at the R> prompt:
-- TABLESTATS.RMD
SET VAR vTableName TEXT
SET VAR vDBName TEXT = (CVAL('DATABASE'))
SET VAR vCap TEXT = ('Tables in the database' & .vDBName)
LABEL lbTop
CHOOSE vTableName FROM #TBLVIEWS +
TITLE 'Choose table -- ESC to exit' +
CAPTION .vCap
IF vTableName = '[Esc]' THEN
GOTO lbExit
ENDIF
WRITE 'Details for table', .vTableName
SELECT Sys_Table_Type=14 as `Type`, +
Sys_Num_Columns=8 as ` Columns`, +
Sys_Num_Rows=12 as ` Rows`, +
Sys_Row_Size=8 as `Row_Size` +
FROM sys_Tables +
WHERE Sys_Table_Name = .vTableName
GOTO lbTop
LABEL lbExit
RETURN
On Wed, Nov 27, 2013 at 4:52 AM, Mohammed Sattar
<[email protected] <mailto:[email protected]>> wrote:
Hi All
How can we see the size of the Table just like we can see the size of
the database RX1...RX4
Mohammed Sattar
Utah Group of Companies
