What Are The Pre-requisites To Modify Datatype Of A Column And To Add

1.	What Are The Pre-requisites To Modify Datatype Of A Column And To Add A Column With Not Null Constraint?
Answer» - 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. - 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.

What Are The Pre-requisites To Modify Datatype Of A Column And To Add A Column With Not Null Constraint?

Answer»

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

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