Mysql Drop

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

Ads

Tutorials   

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)

Advertisements

Share on Google+Share on Google+

Mysql Drop

Posted on: January 20, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Mysql Drop  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads