To add a NULL column to a table,we ________.
A)use the REVISE TABLE command
B)use the ALTER TABLE command
C)use the MODIFY TABLE command
D)create a new table with the NULL column,move the other data,and drop the old table
E)None of the above is the correct way to add a NULL column.

Question

Quizplus · Accepted Answer

The ALTER TABLE command is used to make changes to an existing table, such as adding a new column. To add a NULL column, we can use the ADD COLUMN keyword with the NULL option. For example, the syntax would be:
ALTER TABLE table_name ADD COLUMN column_name datatype NULL; 
This will add a new nullable column to the table.

To Add a NULL Column to a Table,we ________