error while changing the field name....

[craily]

Hello there,
A table has one field "idActividad" that is autonumerique and primary key. I need to change the name of the field to "idActividadXCentro", but it send error:
ALTER TABLE 'yachar'.'actividadespreventiva' CHANGE COLUMN 'idActividad' 'IdActividadXCentro' INTEGER UNSIGNED NOT NULL DEFAULT 0,
DROP INDEX 'Index_1'
ADD INDEX 'Index_1' USING BTREE('IdActividadXCentro');
Any advice please?
Thank you very much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Renne]

Try to create idActividad as UNSIGNED, that might solve your purpose. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --