Re: [sqlite] How do I add primary key on existing table?

[Dan]

On Jan 21, 2008, at 1:24 PM, Mohd Radzi Ibrahim wrote:

Hi,

I was trying to add a primary key to existing table but could not.

"alter table custsales add constraint pk_custsales primary key (id, type)"

Is this supported? Is there a different syntax to do this?

Using ALTER TABLE to add a constraint or a new column marked as
PRIMARY KEY is not supported. You can get pretty much the same
effect by doing:

  CREATE UNIQUE INDEX custsales_i ON custsales(id, type);

Dan.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------