public List <CommandResult> REMOVE_SCAFFOLD(IConnectToDB _Connect, string Name, bool PreserveTable, bool PreserveProcedures)
{
List <CommandResult> results = new List <CommandResult>();
CommandResult _result = new CommandResult();
ER_DDL ddl = new ER_DDL();
results.Add(new CommandResult {
_Response = "--Start Remove Scaffold " + Name + "", _Successful = true
});
if (!PreserveProcedures)
{
results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_I_" + Name + ""));
results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_U_" + Name));
results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_D_" + Name));
results.AddRange(ddl.DROP_PROCEDURE(_Connect, Name + "O_"));
results.AddRange(ddl.DROP_PROCEDURE(_Connect, "SP_S_" + Name + "_SEARCH"));
//results.AddRange(DROP_PROCEDURE(_Connect, Name + "_SEARCH_COUNT"));
}
if (!PreserveTable)
{
results.AddRange(ddl.DROP_TABLE(_Connect, Name));
}
results.Add(new CommandResult {
_Response = "--End Remove Scaffold " + Name + "", _Successful = true
});
return(results);
}
