DIAGNOSE

This statement execute DIAGNOSE of the specified database or tables or fields.

diagnose
    :    DIAGNOSE DATABASE [ verbose_level ]
    |    DIAGNOSE TABLE table_name_list [ verbose_level ]
    |    DIAGNOSE FIELD table_dot_column_list [ verbose_level ]

verbose_level
    :    [VERBOSE] { NONE | LOW | NORMAL | HIGH | VERYHIGH }

table_name_list
    :	table_name , ...

table_dot_column_list
    :	table_dot_column, ... 

table_dot_column
    :	table_name.column_name

[verbose_level]

Specifies how many information will be produced in the log file, but not affect how good diagnose is executed, in any case all database objects are tested.

table_name_list

The list of names of Tables to be diagnosed.

table_dot_column

The list of full names of Fields to be diagnosed.

As result of DIAGNOSE command work is a text file, produced in the same folder where the database is located.

DIAGNOSE DATABASE;
DIAGNOSE DATABASE VERYHIGH;
 
DIAGNOSE TABLE tblPerson;
 
DIAGNOSE FIELD tblPerson.fldFirstName;