Purpose
This statement is used to drop an outline in OceanBase Database.
Syntax
DROP [FORMAT] OUTLINE outline_name
Parameters
| Parameter | Description |
|---|---|
| outline_name | The name of the outline to be dropped. |
Examples
Create an employees table and the corresponding outline, and then drop the outline.
obclient> CREATE TABLE employees (emp_id INT, emp_name VARCHAR(20));
obclient> INSERT INTO employees VALUES (1, 'John'), (2, 'Alice');
obclient> CREATE OUTLINE emp_query_outline ON SELECT * FROM employees WHERE emp_id=1;
obclient> DROP OUTLINE emp_query_outline;
obclient> DROP TABLE employees;