Ken Masters
Ken Masters

Reputation: 281

How to drop Materialized view in Azure Synapse Analytics

How to drop materialized view in Azure Synapse Analytics ?

I tried DROP MATERIALIZED VIEW [schema_name].[table_name] but it did not work. I also attempted to find the doc regarding this but surprisingly, there are none.

Upvotes: 0

Views: 390

Answers (1)

Utkarsh Pal
Utkarsh Pal

Reputation: 4544

Use ALTER to drop the materializes view.

Syntax:

ALTER MATERIALIZED VIEW [ schema_name . ] view_name
{
      REBUILD | DISABLE
}
[;]

Example:

ALTER MATERIALIZED VIEW My_Indexed_View DISABLE;

Upvotes: 2

Related Questions