-
Click Edit > Turn AutoValidation On to automatically validate the schema and data files.
Turning automatic validation on helps you identify actions he is performing that cause validation warnings and errors. If automatic validation is turned on and the user takes corrective steps to fix the problems as they arise, then the number of problems detected during full validation should be significantly less.
When automatic validation is turned on, any object created or modified during a command is validated when that command is completed. The validation uses many of the same checks used when a full validation of the schema is executed, but performs the check only against the set of objects created or modified during the command. The Schema Editor displays validation errors in the Validation Errors and Warnings dialog box for your review.
The use of automatic validation does not preclude the use of full validation since there are some checks that are only performed during full validation and the partial validation performed at the end of each command when automatic validation is on is insufficient to validate that the entire set of objects are error-free.
Turning on automatic validation may slow performance of the Schema Editor. To improve
performance, turn off automatic validation and address validation problems with a
full validation on the schema rather than at the end of each command.