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, 1510🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...