List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:September 15 1999 6:39pm
Subject:Re: Removing an index
View as plain text  
Craig Vincent wrote:
> 
> What is the command to remove an index off a table?
> 
> Craig Vincent

Hi Craig

How about:
ALTER TABLE yourTable DROP INDEX indexname;
or:
ALTER TABLE yourTable DROP PRIMARY KEY;

Tschau
Christian

Thread
A problem with the MyODBCDaniel Ruiz15 Sep
  • Removing an indexCraig Vincent15 Sep
    • Re: Removing an indexFraser MacKenzie15 Sep
    • Re: Removing an indexJeff Urban15 Sep
  • Re: Removing an indexChristian Mack15 Sep
  • A problem with the MyODBCMichael Widenius18 Sep
RE: Removing an indexDarren L Sweeney15 Sep