Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to delete table/database in MySQL?

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 112
    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 :)

 0 Comment(s)

Sign In
                           OR                           
                           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: