DROP VIEW

Description

Forcibly deletes a view from the database.

Precautions

The owner of a view, owner of the schema of the view, users granted with the DROP permission on the view, or users granted with the DROP ANY TABLE permission can run the DROP VIEW command. By default, the system administrator has the permission to run the command when separation of duties is disabled.

Syntax

DROP VIEW [ IF EXISTS ] view_name [, ...] [ CASCADE | RESTRICT ];

Parameters

• IF EXISTS

  Reports a notice instead of an error if the specified view does not exist.

• view_name

  Specifies the name of the view to be deleted.

  Value range: an existing view name

• CASCADE | RESTRICT
  • CASCADE: allows cascade deletion of the objects (such as views) that depend on the table.
  • RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.
    

    This attribute is supported only as syntax but does not take effect when the version of an M-compatible database is s1 or later (for example, the version compatibility control parameter m_format_dev_version is set to 's1').

Examples

See Example in section "CREATE VIEW."

Helpful Links

ALTER VIEW and CREATE VIEW