What are the pre requisites ? I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ?

 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.