ALTER TABLE and ALTER VIEW commands: Enable drop operation when a row access policy is not set¶

The ALTER TABLE … DROP ALL ROW ACCESS POLICIES command and ALTER VIEW … DROP ALL ROW ACCESS POLICIES command behave as follows:

Before the change:

For example, if a row access policy is not set on the table and you try to run an ALTER TABLE … DROP ALL ROW ACCESS POLICIES command, Snowflake returns the following error message:

Any policy of kind ROW_ACCESS_POLICY is not attached to TABLE T1.

Copy

After the change:

If a row access policy is not set on the table and you try to run an ALTER TABLE … DROP ALL ROW ACCESS POLICIES command, Snowflake returns a successful status message:

+----------------------------------+
| status                           |
|----------------------------------|
| Statement executed successfully. |
+----------------------------------+

Copy

This change can simplify your workflow scripts because you no longer need to have a workaround when Snowflake returns the error message.

Ref: 1327