Let´s imagine I have a certain dbo.tableOld that must be substituted by a certain dbo.tableNew. Their are almost identical, the only difference (in terms of fields) is that the old one has a certain nvarchar(3000) field and the new one has the corresponding field as nvarchar(max). (I had to make this change.)
I would like to do the following procedures:
01. Drop the dbo.tableOld
02. Rename dbo.tableNew to dbo.tableOld
In other words, I want to put the new one "over" the old one, everything else (views, store procedures, etc) not being disturbed during this change.
Question: can I do as I intend or should I do this in another way?
The most important think is in bold, that is, I do not want to mess up with all database structures that are related to the dbo.tableOld, just make the new one to be the old one, so to speak.