At 23:26 -0500 11/4/02, Eric Frazier wrote:
Hi,
This is a why questionk, which may be somewhat pointless, but. Why is this
under alter table instead of drop index?
Because DROP INDEX cannot be used to drop a PRIMARY KEY.
Just like CREATE INDEX cannot be used to create a PRIMARY KEY.
Thanks,
William R. Mussatto wrote:
From an SQL point of view, shouldn't the existing primary key be replaced
by another so that each row is ALWAYS uniquely addressable.
Unique addressability is something that is not an inate property of all
SQL tables; only ones that have UNIQUE or PRIMARY keys, so
On Tue, 5 Nov 2002, Alan McDonald wrote:
> Date: Tue, 5 Nov 2002 18:49:22 +1100
> From: Alan McDonald <[EMAIL PROTECTED]>
> To: Eric Frazier <[EMAIL PROTECTED]>, Paul DuBois <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: RE: Removal of Primary Key in Mysq
DuBois
> Cc: Uma Shankari T.; [EMAIL PROTECTED]
> Subject: Re: Removal of Primary Key in Mysql
>
>
> Hi,
>
> This is a why questionk, which may be somewhat pointless, but. Why is this
> under alter table instead of drop index?
>
> Thanks,
>
> Eric
>
> At
Hi,
This is a why questionk, which may be somewhat pointless, but. Why is this
under alter table instead of drop index?
Thanks,
Eric
At 01:10 AM 11/5/02 -0600, Paul DuBois wrote:
>At 12:08 +0530 11/5/02, Uma Shankari T. wrote:
>>Hello,
>>
>> I have set one of my field in the mysql table as
At 12:08 +0530 11/5/02, Uma Shankari T. wrote:
Hello,
I have set one of my field in the mysql table as primary key..no i want
to remove that primary key setting in mysql..Can anyone please tell me how
to do that ???
Regards,
Uma
ALTER TABLE tbl_name DROP PRIMARY KEY;
---
Hello,
I have set one of my field in the mysql table as primary key..no i want
to remove that primary key setting in mysql..Can anyone please tell me how
to do that ???
Regards,
Uma
-
Before posting, please check:
http://w