What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?
Gaurav Malviya
- 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.