public void ReturnsFalseWhenSchemaDoesntExist()
{
var schemaName = "unknownSchema";
var hasTable = tester.HasTable(schemaName, tableName);
Assert.IsFalse(hasTable);
}
public void Will_Drop_Table_If_Exists()
{
DropAndCreateTable(schemaName, tableName);
tester.DropTable(schemaName, tableName);
Assert.IsFalse(tester.HasTable(schemaName, tableName));
}
public void StatementExecutes()
{
var sql = "drop table if exists [dbo].[testtable]; create table [dbo].[testtable]([col1] int);";
tester.ExecuteStatementWithoutResult(sql);
var statementSuccessful = tester.HasTable("dbo", "testtable");
Assert.IsTrue(statementSuccessful);
}