In SAP MaxDB, the SQL statement DROP VIEW (drop_view_statement) is used to drop all synonyms and view tables that are based on the view table.
SQL Statements: Differences