Feedback Edit

.alter materialized-view autoUpdateSchema

  • Article
  • 2 minutes to read

Sets the autoUpdateSchema value of an existing materialized view to true or false. For information on the the autoUpdateSchema property, see materialized view create command properties.

.alter materialized-view MaterializedViewName autoUpdateSchema [true|false]

Note

You must either be the database user who created the materialized view or have database admin permission to run this command.

Examples

.alter materialized-view MyView autoUpdateSchema true

.alter materialized-view MyView autoUpdateSchema false