Originally posted by ngwh
hi,

I have got someone telling me that whenever we perform any Alter Table.....it is effectively invalidating all procedures related to that table? is this TRUE?
No, not quite. Only some of the ALTER TABLE comands (basicaly only those which change the table's "visible" structure) indeed cause dependant procedures to be invalidated, but there are many ALTER TABLE clauses that actually have no effect on related procedures..