Procedure documentationDeleting View Tables Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You are the owner of the view table or have DROPIN privilege for the schema to which the view table belongs.

    More information: SQL Reference Manual, Privilege Specification for a Schema (schema_priv_spec)

  • The database is in the ONLINE operational state.

Procedure

  1. Select the view table in the explorer tree.

  2. In the context menu of the view table, choose Delete.

Result

The system deletes the view table definition along with synonyms, view tables, and privileges that are dependent on this view table. Deleting a view table does not affect the table on which the view table is based.

More Information

SQL Reference Manual, DROP VIEW Statement (drop_view_statement)