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

[Mohd Radzi Ibrahim]

On 21-Jan-2008, at 3:12 PM, Dan wrote:

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.

Thanks for the suggestion. Will it still work for the REPLACE command  
to identify indentical record?

--radzi--

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