PDA

View Full Version : SQL help...

FleaBag
06-10-2002, 01:57 PM
This might be completely obvious, but what's the opposite of this query [i.e. remove the changes I made when running it]? Thanks.


ALTER TABLE thread ADD articleid int(10) unsigned DEFAULT '0' NOT NULL;
ALTER TABLE thread ADD INDEX(articleid);
Admin
06-10-2002, 02:41 PM
DROP INDEX articleid ON thread;
ALTER TABLE thread DROP articleid;
:)
FleaBag
06-10-2002, 02:42 PM
FireFly you are a living legend, thanks once again! :)