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]>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
>
>
>
