Click Validate in the Schema section of the Database Options dialog box to launch the Schema Validation dialog box.

Validation attempts to determine whether the statement and column information for the selected schema matches the tables and columns in the database the connection string on the Data Link Options section specifies.

The Schema Validation dialog box contains the following controls:

• Message Level —Shows the level of messages displayed in the list box.
  • Errors and Warnings —Displays both errors and warnings in the list box.
  • Errors Only —Displays only errors in the list box.
  • Warnings Only —Displays only warnings in the list box.
• Differences —Displays the differences TestStand found when comparing the schema to the data source.
• SQL Tools —The SQL commands to generate when you click the Generate SQL button. The ring control contains the following options:
  • Add Missing Items —Generates SQL commands to insert the missing tables and columns listed in the Differences control.
  • Drop All Schema Tables —Generates SQL commands to delete the tables the schema defines.
  • Clear All Schema Tables —Generates SQL commands to delete the records from the tables the schema defines.
• Generate SQL —Launches the Database Viewer application , opens the data source, and places the generated SQL commands in an Execute SQL window.
• Revalidate —Revalidates the current schema against the database.

See Also

Database Options dialog box

Database Viewer