Basic Oracle Concepts and Programming Question:

How To Drop an Existing Table?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

If you want to delete an existing table and its data rows, you can use the DROP TABLE statement as shown in this script:

SQL> connect HR/globalguideline
Connected.

SQL> CREATE TABLE emp_dept_10
2 AS SELECT * FROM employees WHERE department_id=10;
Table created.

SQL> DROP TABLE emp_dept_10;
Table dropped.

Be careful, when you use the DROP TABLE statement. All data rows are gone too.


Previous QuestionNext Question
How To Rename an Existing Table?How To Add a New Column to an Existing Table?