community.borland.com

Article #25658: Table Backversions - How to Determine

Problem:
How do I determine the backversions for a non-system table?

Solution:
The information in this article applies to:

* InterBase 4.x
* InterBase 5.x

Run a  query against the RDB$RELATIONS system table.  The RDB$FORMAT column is just
a counter of how may times the table has been backversioned; it never resets to 0.  For example,

DB$RELATION_NAME                RDB$FORMAT 
=============================== ========== 

COUNTRY                             1 
JOB                                 1 
DEPARTMENT                          2 
EMPLOYEE                            5 
PROJECT                             1 
PHONE_LIST                          1 
EMPLOYEE_PROJECT                    1 
CUSTOMER                            4 
SALES                               4 
PROJ_DEPT_BUDGET                    1 
SALARY_HISTORY                      1 

Last Modified: 24-OCT-00