Mysql Drop

Mysql Drop is used to remove or delete the table from the database.

Understand with Example

The Tutorial illustrate an example from 'Mysql Drop'.To understand this example we create a table 'stu' with required fieldname and datatype respectively.The create table keyword is used to create a table 'Stu'.

Create table

Create Table Stu(Id int,Name Varchar(15));

Query for drop table

The drop query is used to delete or remove the table from database.When you view the output of the given below query the table 'Stu' does not exists anymore in the database.

Drop Table Stu;

Query OK, 0 rows affected (0.03 sec)