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, 1617🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...