SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Question Remove a flag from a table column?

    Went back and removed most of this post.. it all comes down to.. how do I remove the UNIQUE flag from one of the columns in a table I made? I can't figure out the ALTER statement or whatever.

    Thanks!

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL...?

    that's a UNIQUE index. if the index was on the column `foo', and you didn't name the index something else, you can remove it with this query:

    Code:
    ALTER TABLE table DROP INDEX foo
    this will also work:

    Code:
    DROP INDEX foo ON table
    not sure which is the "standard" way.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •