On 16 Feb 2004 at 12:46, Bill Marrs wrote:
> Is there a way to set "PACK_KEYS=1" on existing tables without doing a
> dump and load?
>
> I didn't find it in the "ALTER TABLE" syntax.
It's there. "alter_specification" can be "table_options", and
(looking at the "CREATE TABLE" syntax) "table_options" can be a
single "table_option", and "table_option" can be "PACK_KEYS = 1".
So the syntax is just
ALTER TABLE table_name PACK_KEYS = 1;
--
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org
