>Can you programmatically make a CANDIDATE key into a PRIMARY key so is you were to MODI TABLE afterwards, you'd see the old CANDIDATE type key now appearing as PRIMARY?
yup. Use syntax like this:
ALTER TABLE 'Mytable' ADD PRIMARY KEY myPK TAG MyPK
As when overwriting any index, if SET SAFETY is ON, you will get a dialog asking if the index should be overwritten.
Erik Moore
Clientelligence