public void TestDropSqlNoSchema()
{
Assert.AreEqual(@"
IF EXISTS(
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'TEST'
) DROP TABLE [TEST];
", SqlTemplates.DropTable("TEST", string.Empty));
}
public void TestDropSql()
{
Assert.AreEqual(@"
IF EXISTS(
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'TEST'
) DROP TABLE [dbo].[TEST];
", SqlTemplates.DropTable("TEST", "dbo"));
}