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