¡¡

Ä«Å×°í¸®    Äõ¸®,sql¹®, Á¶°Ç¹® Á¶È¸:4241
 Á¦¸ñ   SQL command to delete a table

**************************************************************************************

  SQL command to delete a table

*******************************************************************************************

The drop table command is used to delete a table and all rows in the table.

 

DROP table "tablename"

 

Example:

 

DROP table employee;

 

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.

************************************************************************************