SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Apr 23, 2002, 17:42 #1
- Join Date
- Aug 2000
- Location
- Philadephia, PA
- Posts
- 20,578
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
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!Try Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more
-
Apr 23, 2002, 17:55 #2
- 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
Code:DROP INDEX foo ON table
- 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