List:General Discussion« Previous MessageNext Message »
From:Keith C. Ivey Date:February 16 2004 5:56pm
Subject:Re: Setting "PACK_KEYS=1" on existing tables
View as plain text  
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

Setting "PACK_KEYS=1" on existing tablesBill Marrs16 Feb
  • Re: Setting "PACK_KEYS=1" on existing tablesKeith C. Ivey16 Feb
  • Re: Setting "PACK_KEYS=1" on existing tablesDan Nelson16 Feb