Use the DROP VIEW statement to remove a specified view from the database.
Examples
DROP VIEW sum_of_acct_balances; -- Using schema and view name DROP VIEW acct_manager_schema.sum_of_acct_balances; -- Using catalog, schema, and view name DROP VIEW account_db.acct_manager_schema.sum_of_acct_balances;