I want to create a new column with a default value. I create the column object, and the default object, but cannot bind the default object to the column before the column is added. The only way I can see of doing this is to add the column with AllowNulls=True, then bind the default, and then issue an update on the column to update existing records.
This must be wrong.
Can anyone help me??
Thanks heaps.