I would like to update a DATE column to TIMESTAMP wich shouldn't be a problem because it is essentially just adding some more space

But when I run the command:
alter TABLE T_UPLOADS ALTER COLUMN TS TYPE timestamp

I get the response:
"This operation is not defined for system tables.
unsuccessful metadata update.
Column TS from table T_UPLOADS is referenced in T_PRODUCTS_RFID_AU2 "

It is indeed referenced in T_PRODUCTS_RFID_AU2 but only with an insert of 'NEW'

INSERT INTO T_UPLOADS (
ITEM_ID,
ITEM_TYPE,
STATUS,
TS)
VALUES (
new.IRFID,
'RFID',
'NEW',
'NOW');

It is referenced like this on serveral places in the database and once I select from this field into a TIMESTAMP column.

The places where it is referenced are spread out across and intermingled into the database so I wouldn't want to start droping and recreating everything if avoidable. I am not doing it localy but making a VB program that does the updates remotley so all changes are quite cumbersome so I would like to keep the changes small and simpel as possible.

Any pointers for simple fixes to the problem would be much appreciated.

Tim