Some scripts modify tables from previous scripts or use tables that may have been dropped so that you have to go back through earlier scripts to recreate the tables. This process is cumbersome and also makes it hard to know what state the current tables are at.
Review which tables need to be kept and which ones are safe to drop.
Possible suggestion - prefix tables with the alphanumeric code that matches the script in which is was created or modified, e.g., if a table is created in 05 name the table 05_table_name and if it is modified in 06 save the modified table as 06_table_name instead of overwriting 05_table_name.
Some scripts modify tables from previous scripts or use tables that may have been dropped so that you have to go back through earlier scripts to recreate the tables. This process is cumbersome and also makes it hard to know what state the current tables are at.
Review which tables need to be kept and which ones are safe to drop.
Possible suggestion - prefix tables with the alphanumeric code that matches the script in which is was created or modified, e.g., if a table is created in 05 name the table 05_table_name and if it is modified in 06 save the modified table as 06_table_name instead of overwriting 05_table_name.