Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Drop an Existing Table
How To Drop an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: 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.
2007-05-03, 4629👍, 0💬
Popular Posts:
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
What’s the difference between Unit testing, Assembly testing and Regression testing? Unit testing is...
Write down the equivalent pointer expression for referring the same element a[i][j][k][l]? a[i] == *...
What Happens to Indexes If You Drop a Table? - Oracle DBA FAQ - Managing Oracle Table Indexes If you...
Do events have return type ? No, events do not have return type.