Collections:
Drop an Existing Table 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.
⇒ Add a New Column to an Existing Table in Oracle
⇐ Rename an Existing Table in Oracle
2019-05-25, 1557🔥, 0💬
Popular Posts:
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...