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

  • How to delete an INDEX in a table in MySQL?

    @babita.dhami
    Recommendations Offline Message

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

    mysql index delete index 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: