title: Turn off system versioning of temporal table that is used in indexed views
body: <p>I have a table that is used by a number of indexed views that I want to convert to a temporal table. All the commands to add the necessary columns and to set SYSTEM_VERSIONING=ON with a history table all succeeded. But now I can not disable system versioning with this command</p>
  
  <pre><code>ALTER TABLE [dbo].[MyTable] SET(SYSTEM_VERSIONING = OFF);
  </code></pre>
  
  <p>I get the error
  <code>Cannot ALTER 'MyTable' because it is being referenced by object 'MyIndexedViewThatReferencesMyTable'.</code></p>
  
  <p>It seems impractical to delete all views, alter MyTable, then recreate all views in order to accomplish this. Is there another way to get this table back to non-temporal?</p>