DROP VIEW

DROP VIEW

Syntax

drop_view ::=

Prerequisites

Only the SYS user, the owner of the schema containing the view, and users with the DROP ANY VIEW system privilege can execute the DROP VIEW statement.

Description

This statement is used to drop the specified view from the database.

user_name

This is used to specify the name of the owner of the view to be dropped. If omitted, Altibase will assume that the view belongs to the schema of the user connected via the current session.

view_name

This is used to specify the name of the view to be dropped.

Example

<Query> Drop the view avg_sal.

iSQL> DROP VIEW avg_sal;
Drop success.