After I Alter a table to add a new column - I want to populate all the rows of that new column with a value from a column in another table. If I use a default value in the ALTER command that is an update with a default value.
Is there a way to use a trigger that is kicked off by the setting of the default in the ALTER command. Will the trigger
recognize the setting of the default as an update ? This
column can't be null.