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

[Mohd Radzi Ibrahim]

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?


best regards,
Radzi.


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