We have numerous processes that use a specific view: MyDatabase.dbo.My_View
I'm interested in changing this view from a VIEW to a TABLE by use of running a stored procedure each night that will take the view code and create a literal / actual table in the DB to be used in place of the VIEW in all of our processes.
My question is this:
If I change a view by CREATING a new TABLE with the exact SAME NAME, will I need to do any code changes in any of my processes in order to have the processes use the VIEW code...?
(Note my plan is to DELETE the original VIEW and ONLY have the new table be active in the DB which will have the exact same name as the original view...)
I look forward to any feedback.