/// <summary>
/// Drops the tables with the given table names.
/// <para/>
/// SQL query Example: <para/>
/// DROP TABLE table1
/// </summary>
/// <param name="tableNames">A list of table names to delete.</param>
public override void DropTables(List <string> tableNames)
{
foreach (var tableName in tableNames)
{
SQLQueryBuilder sqb = new SQLQueryBuilder();
sqb.DropTable().AddValue(tableName);
CommitQuery(sqb.ToString());
}
}
/// <summary>
/// Drops the tables with the given table names.
/// DROP TABLE table1
/// </summary>
/// <param name="tableNames">A list of table names to delete.</param>
public override void DropTables(List <string> tableNames)
{
try
{
List <string> tableQueries = new List <string>();
foreach (var tableName in tableNames)
{
SQLQueryBuilder sqb = new SQLQueryBuilder();
sqb.DropTable().AddValue(tableName);
tableQueries.Add(sqb.ToString());
}
CommitBatchQuery(tableQueries);
}
catch (Exception e)
{
throw e;
}
}