From the Edge: Getting R:BASE DB Info without Being Connected Section: Productivity Tools Chapter: Running R:BASE Your Way! Platform: R:SCOPE (Version 7.5)
Yes, the topic is correct!
Now you can get a complete synopses of your R:BASE database information by simply pressing right-click on any .RB1 file using your favorite file explorer.
Completely re-engineered R:SCOPE 7.5 (officially released on 12/08/2004 http://www.rbase.com/products/rscope) also includes a utility to provide all your database information without being connected either via R:BASE or R:SCOPE.
Here's how:
Follow these steps below:
01. Install R:SCOPE 7.5
02. Using your favorite File Explorer on your desktop,
locate an R:BASE database, such as ConComp sample
database in C:\RBTI\RBG7\Samples\ConComp directory
(Figure 1)
03. Highlight ConComp.RB1 file, Right-Click and select
R:BASE Database Info ... from the speed menu options
(Figure 2)
04. Notice the R:BASE Database Information window with the
following tabs: General Information to include:
. Version Flag
. Database Owner (only if NONE)
. File2 Size
. File 3 Size
. File 4 Size
. First Free Block
. Last Free Block
. Free Block Count
. Free Block Status
. Total Number of Tables
. Number of Used Tables
. Total Number of Columns
. Number of Used Columns
. Total Number of Indexes
. Number of Used Indexes
. Mirror Path Tables information to include:
. All System Tables
. Tables
. Views
. Table Type (Table, System View, View
. Column Count
. Row Count
. Number of users currently in row lock mode
. Number of cursors open for this table
. Number of trans users Column information to include:
. Data Type
. Length Indexes information to include:
. Key Type: (PK, FK, Index)
. Associated Table
. Associated Column(s)For more details: http://www.razzak.com/fte (Powered by R:WEB Suite)
Very Best R:egards,
Razzak.
