Thanks, but I'm looking at having this for all objects drop table mytable retain metadata;
etc Dave On Tue, Dec 04, 2001 at 06:52:17PM +0100, Sergei Golubchik wrote: > Hi! > > On Dec 04, David Turner wrote: > > I've always thought it would be great if there was a way to drop an object but > > keep the meta data so I can recreate objects without having to store the ddl > > somewhere. > > > > alter table drop index retain metadata > > > > Would be helpful. > > That's what ALTER TABLE ... DISABLE KEYS is for > > Regards, > Sergei > > -- > MySQL Development Team > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
