public static void AddCheck()
{
var constraint = new SqlTableConstraint(ConstraintType.Check) {
CheckExpression = SqlExpression.Equal(SqlExpression.Reference(new ObjectName("a")),
SqlExpression.Constant(2))
};
var statement = new AlterTableStatement(ObjectName.Parse("test"), new AddConstraintAction(constraint));
var sql = statement.ToString();
var expected = new StringBuilder();
expected.Append("ALTER TABLE test ADD CONSTRAINT ");
expected.Append("CHECK a = 2");
Assert.AreEqual(expected.ToString(), sql);
}