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

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 222
    Comment on it

    We can drop INDEX from table by using DROP INDEX statement, it is used to delete an index form a table.

    Syntax:

    ALTER TABLE table_name DROP INDEX index_name;
    

    Example: Suppose you have created an INDEX named "person_user_name_idx" on the "user_name" column in the "user" table, now you can delete this INDEX by using the below statement

    ALTER TABLE user DROP INDEX person_user_name_idx;
    

    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: