SQL Drop Table

OBJECTIVE

In this chapter you will learn:

SQL drop table statement
Syntax of drop table
Example of drop table

 

SQL drop table statement

As its name suggest drop table so you can easily understand about this statement that it is used to delete table from database. If you have some tables of one table which is not in use then you can delete to release the memory.

Syntax of drop table

drop table table_name

Example of drop table

 

Note:-

When you will run the given command you will get the message command completed successfully and the table od the database will be deleted. When you drop the table you must select the database in which the table exist.

SUMMARY

In this chapter you have learned about drop table statement so if your database has any unused table then you can delete. In the next chapter you will learn about truncate table.


Leave a Reply

Your email address will not be published. Required fields are marked *