Sometimes, you will need to delete off or drop the table from certain Database.

To delete the table and also all the rows inside the table.
SQL syntax will be like this:

DROP TABLE [TABLE NAME]

DROP TABLE is different from deleting all of the rows in the table. This command also will delete off the table and even the table column and constraint information in the database.


EXAMPLE :

We want to drop or delete off a table name GameScores from a database.

SQL statement:

DROP TABLE GameScores