SQL Drop Table

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

drop table employee_info

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.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.