I have created my database and Tables, but need to plan for the future before starting my programming.
Now I need to plan for Future updates, which also goes for updates on my tables. I need to add fields to CURRENT tables if they do not exist in that Table. This will all be done through code also using queries.
I have looked at the Alter table but it gives an error when a duplicate field is added.(<- This is understandable.) But I need the program to ignore fields already added. Any help or suggestions PLEEAASSSEE.