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