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, 1536🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...