To count the records in tables, use the following procedure. If you want to count records while the database is on line, refer to Checking the Database Integrity Dynamically
On DBCHECK's Database Integrity Checking menu, select option 5 - Count records on database
DP4 counts the records and prompts you to select the output destination. The record count is displayed in this format:
|
Record count for database SALESORD |
18 Oct 1994 | ||
|
|
|
|
|
|
Table name |
Record count |
Record size |
Total size (Kilobytes) |
|
COMPANY |
3 |
140 |
1 |
|
CUSTOMER |
182 |
162 |
29 |
|
EMPLOYEET |
42 |
52 |
3 |
|
MATERIAL |
54 |
58 |
4 |
|
ORDER_HEADER |
215 |
56 |
12 |
|
ORDER_LINE |
805 |
36 |
29 |
|
ORDER_PAYMENT |
294 |
52 |
15 |
|
PAYMENT_MEDIA |
9 |
34 |
1 |
|
REGION |
47 |
48T |
3 |
|
SUPPLIER |
6 |
134 |
1 |
Press any key to return to the Database Integrity Checking menu