Wednesday, December 23, 2020
Tip of the Day: Updated Database Properties Utility for all Version Flags
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.3.11222 or higher
Sections......: Database Explorer
Keywords......: Database Properties, Tables, Columns, Indexes, Version Flag
Did you know the Database Properties utility was updated to allow the
dialog to be launched for all available database version flags?
The Database Properties menu option within the "Databases" area of the
Database Explorer open a dialog that displays important information
for the selected database.
When selecting the option a fast connection is made to the database files
to retrieve the current information. That connection may temporarily be
displayed in the information. The dialog will display details regarding
general information, tables, columns, and indexes.
General Information:
Version Flag
Database Owner (only if NONE)
File 2 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
Number of Users Connected
Mirror Path
Tables Information:
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 the table
Number of users in Transaction mode
Column Information:
Datatype
Column Length
Index Information:
Key Type: (PK, FK, Index)
Associated Table
Associated Column(s)
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1Mvan4-1k1uFF23aI-00sgDy%40mrelay.perfora.net.
