adding a column to table w/o destroying existing data

If i add a column to a table will it reset data in other fields. How can I make sure this does not happen or rather how do I achieve this goal. Is it also possible to have that new column have a default value in each of the existing rows. How do i do that.

Thx

Other
1 reply