Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to delete table/database in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 303
    Comment on it

    We can drop table or database by using DROP keyword.

    Syntax:

    The DROP TABLE statement is used to delete a table.

    DROP TABLE table_name;

    The DROP DATABASE statement is used to delete a database.

    DROP DATABASE database_name;

    Example: Suppose you have created table named "user" then the below statement will delete the user table from your database.

    DROP TABLE user;

    You have created database named "demo" then the below statement will delete your database.

    DROP DATABASE demo;

    Hope this will help you :)

    mysql database table drop table drop database
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: