What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?

Gaurav Malviya

11y

1.6k

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

11y