Hi All,

I am receiving below error while altering the table column datatype.



*Reason:SQL Error [0A000]: ERROR: cannot alter type of a column used in a
trigger definition  Detail: trigger extensiontrigger on table tele depends
on column "phonenumber"*

Do I need to drop the trigger and alter the table column to modify the
datatype of the columns. Am I correct? or is there any other way to resolve
it.

-- 
Regards,
Raghavendra Rao J S V

Reply via email to