- 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.