SQL Drop Table

The SQL Drop Table command is used to remove a table, its structure and any data in it.


Usually we can only remove object that we own or have special permission to delete it.

Before you drop a table, you may need to remove all table constrainst, otherwise the system will refuse to delete a table, and generate an error.

Removing a table

The syntax to remove a table:

DROP TABLE table_name

For example, you want to drop the Authors table

SQL Command:

DROP TABLE authors

Quick link. From here, you can learn the following:

Sql Create Database
Use this to create a database.

Sql Create Table
This Sql Create Table will be used very often throughout the tutorial. It is used to create a table, in our case, mainly to create sample tables.

Sql Alter Table
Used less often, but it is very handy to know this command. With this you can basically edit a table structure.

Data Retrieval
All you need to know about Sql Select can be found here.

Go Top

Journey
Buy at AllPosters.com
A bend in the road is not the end of the road... unless you fail to make the turn

Positive Resources

All of us have at least two or three things that excite us. We could talk about these subjects for hours. Good news!. Did you know that Site Built It! can turn this type of deep interest and enthusiasm into a revenue-generating business?

Review some of the Site Build It! case studies and you'll absolutely discover something that ignites more positive ideas into your mind.

SBI! Video Tour


Invest the most
important 30 minutes
you will spend online.

Click, sit back, and
understand why SBI!
makes you succeed.