Question

What should be added so NULL values are not allowed in ProductName? (Ch.4)

Answer 1

To disallow NULL values in the 'ProductName' column, you can use the NOT NULL constraint in SQL.

Step-by-step explanation:

To restrict NULL values in the 'ProductName' column of a table, you can apply a NOT NULL constraint. This constraint ensures that every row in the table must have a non-null value for the 'ProductName' column. To add this constraint, you can use SQL statements like:

ALTER TABLE table_name

MODIFY COLUMN ProductName data_type NOT NULL;

By setting the NOT NULL constraint, you are indicating that the 'ProductName' field cannot be left blank or empty in any record.