VALIDATE DATABASE Command Example

The following example opens the testdata database and uses VALIDATE DATABASE to ensure that the locations of tables and indexes in the database are correct.

CLOSE DATABASES
SET PATH TO (HOME(2) + 'Data\') && Sets path to database
OPEN DATABASE testdata EXCLUSIVE && Open testdata database

VALIDATE DATABASE