-1

I have a partitioned database environment with partitioned tables. Can I alter the column name for the table. I am aware that I cannot do that in following condition:

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

to name a few.

Besides these is there anything else that I should keep in mind?

If, yes what are those and what is the procedure for it?

Thanks

mustaccio
  • 18,234
  • 16
  • 48
  • 57
Aryadhara Das Adhikari
  • 1

1 Answers1

-1

You must thing to:

 -View materialized
 -Storage procedure
 -if your fields is used in Programs or scripts
 -if your field is a key in referential constraint (FK)
 -if your field is primary key (auto  increment same may be)
 -if your table with this field has autotimestamp you change will change all timestamps
 -if your field is used in view or view into view etc
Esperento57
  • 16,521
  • 3
  • 39
  • 45
  • this is to rename a column name that we generally follow. I need clarification on doing so for a partitioned column. Need I follow a different procedure for it or is there any restriction on doing so? – Aryadhara Das Adhikari Jul 22 '16 at 08:17
  • thanks, so if any of the above criteria is met, that means I cannot rename the column any ways, right? And if the condition is okay, I can rename it like normally we do the renaming, right? – Aryadhara Das Adhikari Jul 22 '16 at 08:49
  • yes, or you can enable all and modify all (enough difficult because you must do alter table, alter procedure, alter view, modify your program or scripts, for autotimestamp you must do a copie of table or use may be the clause overiding system value, drop contraint et recreate, alter trigger etc...) . Of course for this change you must control user doesn't working on this table too. (wrkobjlck on db2 on system i) – Esperento57 Jul 22 '16 at 08:57
  • why -1 i dont anderstand? – Esperento57 Jul 22 '16 at 12:46