This documentation is archived and is not being maintained.

Error validating constraint. (Visual Database Tools)

The text of the Constraint Expression property does not conform to the constraint syntax recognized by the DBMS. Some common reasons why a constraint expression can violate the required syntax are:

  • The expression does not resolve to a value of TRUE or FALSE.
  • The expression misspells a column name, or refers to a column in another table.
  • The expression misspells the name of a function or database constant.

For a complete description of the syntax for constraint expressions in SQL Server 2000, see the SQL Server documentation.