I am programming in C# and using a MSSQL Server for my databases. After years I got now the problem, that I realized my table name is not so good.
For example:
Old: DB_Orders
New: DB_CS_Orders (CS = Computer Science Department)
I am basically creating new Tables with the same columns for different departments. (To separate them clean and use different ID/number ranges. (And main purpose that I know in my program dynamically from which department I need to SELECT ... example string TablenamePosition = MainTablename+"Position")).
Usually the tables don't exist and I can create new ones, but now I got some old ones which I want to rename after that new pattern and can't do that since the program is running 24/7. What I did to prevent it, I created views called like the new pattern and start programming like that.
Now the issue I got the views they do not refresh after I alter the main table(Add/Remove Column), even if I use * on the view. Is there better way to redirect just the table name?