Oracle - Drop an Existing Table in Oracle

Drop an Existing Table in Oracle

Q

How To Drop an Existing Table in Oracle?

✍: FYIcenter.com

A

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/fyicenter
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.

⇒Managing Oracle Database Tables

⇒⇒Oracle Database Tutorials

2016-10-17, 169👍, 0💬

Popular Posts:

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

CREATE VIEW - Creati...

How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...