Adding Columns
• To add NULL columns to a table:
• Other column constraints, e.g., DEFAULT or UNIQUE, may be included with the column definition.
• Newly added DEFAULT constraint will be applied to only new rows, existing rows will have null values.
• Three steps to add a NOT NULL column:
– Add the column as NULL.
– Add data to every row.
– Alter the column constraint to NOT NULL.