Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sql-remove Mysql Drop

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Drop

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

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)
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 20, 2009

Related Tutorials

Discuss: Mysql Drop  

Post your Comment


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