public void CanCreateIncludeIndexWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetCreateIncludeIndexExpression();
var sql = generator.Generate(expression);
sql.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC) INCLUDE ([TestColumn2])");
}
public void CanCreateIncludeIndexWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateIncludeIndexExpression();
expression.Index.SchemaName = "TestSchema";
var sql = generator.Generate(expression);
sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC) INCLUDE ([TestColumn2])");
}
