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