It was a long time ago when I asked this question. I only remember: it was not a historizing table, and I think, it was also not an import table, because import tables already have a source. So I think, it was an externally filled table.
I think I remember: I defined a table with manually filled data (I think I used it for some configuration) and later I wanted to create a view (transformation) containing the logic for the table and the view should be persisted. And because I did not get an answer I did something like:
- creating the view with the same structure as the table
- changing all successors of the table to use the new transformation instead of the old table (and there have been a lot of successors)
- adding a persistence to the new transformation
Outside AC, I can easily create a view or another table with the same structure as the table and just switch names:
For example the table is dbo.table_1 I can rename it into dbo.table_1_old and my view will be dbo.table_1 and this will work (not yet persisted, but I can also add a persistence). And then I can refactor the name using free SSDT or some software for smart renaming.
But this was too complicated to do in AC. And additionally I was disappointed, that questions are not answered here in the forum for several weeks. I don't want to depend on urgent instant support. I want to be able to solve issues and tasks quickly, when they happen, not depending on support or implemented features. And after waiting a few weeks for an answer and after analyzing how my feedback, bug reports and feature requests are handled, I decided not to ask this question again ...
BTW, the solution you explained is a bit complicated. I suggest delivering an object scripts which could solve this kind of questions.
