Error validating constraint. (Visual Database Tools)
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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.

© 2016 Microsoft