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); }