I have 70 odd tables where the tables have been changed at some point to make all non key fields 'NOT NULL'

I need to change all of these back to be able to enter nulls. Some of the tables contain data. Is there a way that I can do this in one go rather than modifying each row in 70 odd tables.

Sati