public override void CanAlterColumn()
{
var expression = GeneratorTestHelper.GetAlterTableExpression();
var sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE `TestTable1` MODIFY COLUMN `TestColumn1` VARCHAR(20) NOT NULL");
}
public override void CanAlterColumn()
{
//TODO: This will fail if there are any keys attached
var expression = GeneratorTestHelper.GetAlterTableExpression();
var sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] NVARCHAR(20) NOT NULL");
}
public void CanAlterColumnWithCustomSchema()
{
//TODO: This will fail if there are any keys attached
var expression = GeneratorTestHelper.GetAlterTableExpression();
expression.SchemaName = "TestSchema";
var sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ALTER COLUMN [TestColumn1] NVARCHAR(20) NOT NULL");
}