Collections:
DROP TABLE Statement in Oracle
How To Drop an Existing Table in Oracle?
✍: FYIcenter.com
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.
2020-02-20, 800👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...