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
Post a Comment