My setup: ArcSDE 9.3 ArcCatalog 10.I am trying to change the primary key in a feature class from one field to another. I am using the following command which returns success. sdetable -o alter_reg -t <feature class table> -c <field to use for primary key> -C USER -u <username> -p <password> -i 5151
Now, when i try to delete the field that was previously a primary key throws the error "one or more fields cannot be deleted". I am following the below steps to delete a field from feature class in arccatalog.- Open arccatalog. Locate feature class from connection.- Right click properties.- Go to Fields tab.- Highlight the field and press delete key.I am suspecting one of the following reasons based on my limited knowledge. - Switching primary key did not happen despite the success message running the above command.- I need to enforce the primary key change with a followup command, which i am not aware.Any thoughts would be helpful.ThanksChan