SQL Interpreter and Tutorial with Live Practice Database
|
Drop a Table
The drop table command is used to delete a table and all
rows in the table.
To delete an entire table including all of its rows, issue the
drop table command followed by the tablename. drop table
is different from deleting all of the records in the table. Deleting all of
the records in the table leaves the table including column and constraint
information. Dropping the table removes the table definition as well as all
of its rows.
drop table "tablename"
Example:
drop table myemployees_ts0211;
Drop Table exercises
- Drop your employee table.
SQL Interpreter
Finished with this SQL Tutorial? Continue on at the
SQLCourse2.com site! This site will
provide you with more intermediate & advanced instruction and allow you the
ability to practice everything you learn as well!
|
|