db2 - renaming column for a partitioned table -


i have partitioned database environment partitioned tables. can alter column name table. aware cannot in following condition:

  • it being used in views
  • it referenced in in index definition
  • it check constraints
  • the table has trigger

to name few.

besides these there else should keep in mind?

if, yes , procedure it?

thanks

you must thing to:

 -view materialized  -storage procedure  -if fields used in programs or scripts  -if field key in referential constraint (fk)  -if field primary key (auto  increment same may be)  -if table field has autotimestamp change change timestamps  -if field used in view or view view etc 

Comments