public void CanRemoveDefaultConstraint() { var expression = GeneratorTestHelper.GetDeleteDefaultConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 DEFAULT NULL"); }
public void CanRemoveDefaultConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetDeleteDefaultConstraintExpression(); expression.SchemaName = "USER"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"USER\".\"TestTable1\" MODIFY \"TestColumn1\" DEFAULT NULL"); }