Purpose
You can use this statement to drop an outline from OceanBase Database.
Syntax
DROP [FORMAT] OUTLINE outline_name
Parameters
| Parameter | Description |
|---|---|
| outline_name | The name of the outline to be dropped. |
Example
Create an employee table and a related outline, then delete them.
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;