Exemplos de SqlTemplates.DropTable em C# (CSharp)

Exemplo n.º 1

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

Exemplo n.º 2

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