adding a column to table w/o destroying existing data

mohan ramanujam

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

[Deleted User]

Hi Mohan,

no worries - adding a new column does not affect existing records and therefore won't destroy any existing data.

And it is absolutely possible to set a default value during the creation of the column or by clicking on an existing column name and choosing settings. You'll then be given a "default value" option.

Hope that helps, and happy building!