public static void Empty(SQLSchema Schema)
{
var tables = Schema.BottomUpTableList;
foreach (var table in tables)
{
string tableName = table.Name;
if (Schema.TableNamePrefix != null)
{
tableName = Schema.TableNamePrefix + tableName;
}
DropTable(tableName);
}
}
public static void DeleteFrom(SQLSchema Schema)
{
var tables = Schema.BottomUpTableList;
foreach (var table in tables)
{
string tableName = table.Name;
if (Schema.TableNamePrefix != null)
{
tableName = Schema.TableNamePrefix + tableName;
}
string sql = "delete from [" + tableName + "]";
Execute(sql);
}
}
public SQLTable(string name, SQLTable parent, SQLSchema schema)
{
Name = name;
Parent = parent;
Schema = schema;
}
public SQLTable(string name, SQLSchema schema)
{
Name = name;
Schema = schema;
}
