SQL Delete Database

SQL Delete database table

 Use the drop TABLE command in the SQL language to delete a table and all records in that table. The use format of the drop TABLE command is:

drop table TableName;

 Example: drop table employee;  If a user wants to delete a database table completely, simply enter the name of the table that you want to delete after the drop table command. The drop TABLE command works differently from all records in the delete table. After you delete all the records in the table, the table still exists and the information in the table is not changed. Using the drop TABLE command removes all information from the entire database table.

 above, we introduce the main commands and statements of SQL language in more detail. It should be said that the syntax of the SQL sentence structure and style is quite simple and intuitive, as long as the user combined with practice more practice, will be quickly mastered in the short term.

 in the case of a store_information datasheet, we can set the following fields and table aliases in the SQL command used in the Group by section:

select A1.store_name Store, SUM (sales) "Total Sales" from store_information a1group by A1.store_name query results are displayed as: s Tore Total Saleslos Angeles $1800san Diego $250boston $700