For example, I alter a column in a table to be not null from null.
I need to then delete and readd the table. That part is pretty clear.
What about views, functions, and stored procedures that access the table, especially that column in the table?
I've tried running diffs against the files generated by SQLMetal with some limited success, but even with that it's fairly unclear.
I know there is at least one commercial tool out there that claims to address this problem, but I am looking for something free.
How are people dealing with this issue?