To delete a view, use the DROP VIEW statement.
The deletion of a view does not delete the tables it references. If you delete a view that is referenced by another view, queries on the view that references the deleted view fail.
Delete a view
Share
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
All Products
OceanBase Database
SQL - V2.2.77Enterprise Edition
Download PDF
What is OceanBase Database? Benefits System architecture Features Compatibility with Oracle Database SQL data types Built-in functions System views Compatibility with MySQL Scenarios Technical standards Related services Overview Overall architecture Basic conceptsCluster management Tenant and resource managementData distributionReplicas and services Data balancingMulti-tenant architecture Compatibility modes System tenantGeneral tenantTable and table group Secondary index Tables without a primary keyViews High availability solutionDeployment modes REDO log management Isolation level Concurrency control GTS Local transactionDistributed transaction Distributed queryOverviewLSM-tree architecture MemTable Block storage (SSTable) Minor compaction and major compaction Caching Read and write process DDL Execution process of SQL queries Data linkODP Database driver OverviewBackup architecture Restoration architecture Backup setArchive log roundOverviewTypical scenariosProtection modeRole switchover Log transfer servicePrimary/standby database configuration Deployment introduction Deployment process Prepare servers Server configuration requirements Prepare the installation packages Deployment description Check after deployment Configure DNS (optional) Add an OBServer to the OCP resource pool Create an OceanBase cluster Deployment description Deploy OBProxyView available resources of a business tenant Create a tenant Verification after deployment Deployment description Check after deployment Deployment description Check after deployment Overview Connect to a MySQL tenant from a MySQL client Use OBClient to connect to an OceanBase Database tenant Database operations Table operations Index operations Insert data Query data Update data Delete data Commit a transaction Roll back a transaction Table-level operations Index operations Insert data Query data Update data Delete data Commit a transaction Roll back a transaction Basic database components