pcplans.com § Help and Support How to: using SQL to Drop a Table  

How to: using SQL to Drop a Table

Article ID:8915
Last Review:Thursday, January 08, 2009
Revision:3.0

INTRODUCTION

How to: using SQL to Drop a Table

symptomsIMPORTANT

How to: using SQL to Drop a Table


IMPORTANT

How to: using SQL to Drop a Table
Dropping the table removes the table definition as well as all of its rows.
Dropping the table removes the table from the database for good
back to the top

How to: using SQL to Drop a Table


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 employee;



Drop Table exercises
Drop your employee table.




  • NOTE: How to: using SQL to Drop a Table
  • back to the top




    Last Reviewed:1/8/2009
    Keywords: kbHow kbhowtoHow kbHOWTOHow #8915 kbAudITProHow



        Contact

       ©1999-2008 Support at pcplans.com