- To modify the datatype of a column the column must be empty.
- To add a column with NOT NULL constrain, the table must be empty.