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 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)
Posted on: January 20, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles