table design changes

[alexl]

I am trying to change the default value and validation rule for a field in a table as well as delete a field in a table. These are existing fields, not newly created. So far, all I have found indicates this can't be done in code; is there a way to do this in a macro?

 

[cpuSmoker]

umm, why?

I believe it may be possible to update the default value of a field, but not delete a field. Why would you need to delete a field in a table more than once? All data contained would be irratrevable. If this field is temporary in nature, why not simply update the data in that field to empty or null?