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