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.
⇒ CREATE INDEX - Create a Table Index in Oracle
⇐ ALTER TABLE - Delete a Column in Oracle
2020-02-20, 1774🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...